Return the week number of the current date


 AB
1=TODAY() = Sunday, June 01, 2025 
2=NOW() = Sunday, June 01, 2025 
3=ISOWEEKNUM((A1)) = 22 
4=TRUNC(((A1-DATE(YEAR(A1), 1, 0))+6)/7) = 22 
5=INT((A1-DATE(YEAR(?-4337), 1, 1))/7)+1 = 6545 

Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date serial number of the current system date and time.
ISOWEEKNUM - The week number in the year for a given date (based on European convention).

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top