Wekk numbers and dates

A

Alex H

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
 
B

Bob Phillips

Alex,

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

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