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