software

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

Gino,
There are 2 or 3 ways of numbering weeks see
www.cpearson.com/excel/weeknum.htm

This discussions in excel.worksheet.functions may help too
tinyurl.com/7acy5

Barbaraquot;Ginoquot; gt; wrote in message
...
gt;I know I can get the week number with the function weeknum(). But now, I
gt;need
gt; to get the date of a week number. My report must say From mm/dd/yyyy to
gt; mm/dd/yyyy and not Week n.
gt;
gt; Thanks for your help
Thank you Barbara. I really appreciate it. The second link was really useful.

quot;Barbara Wisemanquot; wrote:

gt; Gino,
gt; There are 2 or 3 ways of numbering weeks see
gt; www.cpearson.com/excel/weeknum.htm
gt;
gt; This discussions in excel.worksheet.functions may help too
gt; tinyurl.com/7acy5
gt;
gt; Barbara
gt;
gt;
gt; quot;Ginoquot; gt; wrote in message
gt; ...
gt; gt;I know I can get the week number with the function weeknum(). But now, I
gt; gt;need
gt; gt; to get the date of a week number. My report must say From mm/dd/yyyy to
gt; gt; mm/dd/yyyy and not Week n.
gt; gt;
gt; gt; Thanks for your help
gt;
gt;
gt;