ExcelBanter - How can I create formula that turns a date into the week # in

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I create formula that turns a date into the week # in (https://www.excelbanter.com/excel-discussion-misc-queries/728-re-how-can-i-create-formula-turns-date-into-week.html)

don

How can I create formula that turns a date into the week # in

THANK YOU!!!!!!!!!!!!!. this did the trick.

"JE McGimpsey" wrote:

WEEKNUM will work if you have the Analysis Toolpak Add-in installed
(Tools/Add-ins... check the appropriate checkbox).

In article ,
don wrote:

Don't know if I made sense when I typed this...
1/1/04 would be 1 for the 1st week in the year.
2/10/04 would be given value 6 for the 6th week of the year, etc.
thanks

All times are GMT +1. The time now is 04:26 PM.