Wekk numbers and dates
 

i have a chart in which I need to match the week number up with the Saturday
of that week. Can someone suggest an easy way of doing this please

thanks
A

try this url

www.cpearson.com/excel/weeknum.htm

=================
Alex H wrote in message
...
i have a chart in which I need to match the week number up with the
Saturday
of that week. Can someone suggest an easy way of doing this please

thanks
A

Alex,

=DATE(2005,1,1)+(C1-1)*7

seems to work, where C1 is the weeknum, as defined in Excel (i,.e not ISO)

--
HTH

Bob Phillips

"Alex H" wrote in message
...
i have a chart in which I need to match the week number up with the
Saturday
of that week. Can someone suggest an easy way of doing this please

thanks
A