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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Testing a cell value for a specific weekday. 4
Show week number in Project Report 0
Creating a Chart on form from selected data in query. 0
Space at end of multi page list to accommodate new entries 1
How to create a bubble chart with more than 2 variables. 0
Resource name inside resource sheet: per person, work per hours per week 0
calculating volatility 0

Top