Return the week number of the current date


 AB
1=TODAY() = Monday, December 02, 2019 
2=NOW() = Monday, December 02, 2019 
3=ISOWEEKNUM((A1)) = 49 
4=TRUNC(((A1-DATE(YEAR(A1),1,0))+6)/7) = 48 
5=INT((A1-DATE(YEAR(?-3099),1,1))/7)+1 = 6258 

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
ISOWEEKNUM - (2013) The number of the ISO week of the year for a given date.

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