Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get the monday of a given week number?
I know I can get the week number with the function weeknum(). But now, I need
to get the date of a week number. My report must say From mm/dd/yyyy to mm/dd/yyyy and not Week n. Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get the monday of a given week number?
Gino,
There are 2 or 3 ways of numbering weeks see http://www.cpearson.com/excel/weeknum.htm This discussions in excel.worksheet.functions may help too http://tinyurl.com/7acy5 Barbara "Gino" wrote in message ... I know I can get the week number with the function weeknum(). But now, I need to get the date of a week number. My report must say From mm/dd/yyyy to mm/dd/yyyy and not Week n. Thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get the monday of a given week number?
Thank you Barbara. I really appreciate it. The second link was really useful.
"Barbara Wiseman" wrote: Gino, There are 2 or 3 ways of numbering weeks see http://www.cpearson.com/excel/weeknum.htm This discussions in excel.worksheet.functions may help too http://tinyurl.com/7acy5 Barbara "Gino" wrote in message ... I know I can get the week number with the function weeknum(). But now, I need to get the date of a week number. My report must say From mm/dd/yyyy to mm/dd/yyyy and not Week n. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting by week number?????? | Excel Discussion (Misc queries) | |||
evaluate data by week number | Excel Worksheet Functions | |||
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? | Excel Worksheet Functions | |||
how to get week number in month in excel ? | Charts and Charting in Excel | |||
Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions |