Date Formula Help

[SMonczka]

Someone here once gave me the formula for converting a Date to the
number of the week. In other words 1/16 would be 3 as it falls on the
3 week of the year. Would anyone hapen to know that formula. I lost
it.

Thanks for the help.
Steve

 

[Norman Harker]

Hi Steve!

See:
Chip Pearson:
http://www.cpearson.com/excel/weeknum.htm

A variety of formulas for use with vary definitions of week number.

 

[SMonczka]

Norman, thank you very much this was the artical i was looking for.

 

[SMonczka]

Norman, thank you very much this was the artical i was looking for.

 

[SMonczka]

Norman, thank you very much this was the artical i was looking for.