Week 1 in 2007 started on 01 01 07 or day number 39083
week 5 would start on day number 39083+ 4*7

or monday 29 01 07


--
Greetings from New Zealand

"brian martens" wrote in message
oups.com...
I have a set of date that needs to be summarized by week. I am using
weeknum to figure out appropriate week for each value and them using
sumif to roll those up week by week. My one remaining problem is
getting dates to display for each week based on the week number. In
other words I want the starting date to display for a week number 6, or
the starting and ending dates, even the ending date for that week. If
I can do that based on week number then I can label the summarized data
set. Any thoughts on how to do that? I've searched for hours now and
no luck.