Formula to read date line as which week in the year, must be formula not macro

[paquirl]

cell contains a date, example 9/1/2023 1:43
the column has many dates in this format but all different actual dates throughout the year spanning a few years
need formula that determines which week of the year the date falls into, the year having 52 weeks

 

[SanjayGMusafir]

Are you looking for this - Check and revert -

Book2
	G	H	I
22	10/24/23	44	44 of 2023
23	10/24/23 20:03	44	44 of 2023
Sheet1

Cell Formulas
Range	Formula
G22	G22	=TODAY()
H22:H23	H22	=WEEKNUM(G22,11)
I22:I23	I22	=WEEKNUM(G22,11)&" of "&YEAR(G22)
G23	G23	=NOW()

 

[paquirl]

can you tell me how to put that in? that is some wild stuff! i may not be smart enough to do this

 

[SanjayGMusafir]

You have formula to copy from my above post #2. Just copy and use it. All you might need is to change the cell address where date is...

Try and revert

 

[paquirl]

GREAT THANKS!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.