ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Week of the Year (https://www.excelbanter.com/excel-discussion-misc-queries/88396-week-year.html)

Ed

Week of the Year
 
Hello, does anybody know a way to have a date writtenin a cell and have
another cell tell to which week of the year it belongs?

thanks,


Bob Phillips

Week of the Year
 
In the other cell, add

=WEEKNUM(A1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ed" wrote in message
...
Hello, does anybody know a way to have a date writtenin a cell and have
another cell tell to which week of the year it belongs?

thanks,




Ed

Week of the Year
 
Thank you!


All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com