Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Week of the Year
Thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
first week of year - according to european standard | Excel Worksheet Functions |