View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barbara Wiseman
 
Posts: n/a
Default 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