Return the week number of the current date

	A	B
1	=TODAY() = Monday, April 01, 2024
2	=NOW() = Monday, April 01, 2024
3	=ISOWEEKNUM((A1)) = 14
4	=TRUNC(((A1-DATE(YEAR(A1), 1, 0))+6)/7) = 14
5	=INT((A1-DATE(YEAR(?-4323), 1, 1))/7)+1 = 6484

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 - (2013) The number of the ISO week of the year for a given date.