Add a start date from a day number and a week

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am working on a spreadsheet and I need to add a start date from a day number and a week number. I have a 4 week cycle:

4th week: 23/11/2009 start date
1st week: 30/11/2009 start date
2nd week: 07/12/2009 start date
3rd week: 14/12/2009 start date

Ie:
Day: 2 (Tuesday)
Week: 2
Start Date: 01/12/2009

Below would be my columns:

Day Week Start Date
1 2 ?
1 3
3 1
4 2
5 4
4 2

Thanks very much

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
your data base must be sosmething like this
A B C D E F G
Day Week SATART DATE WEEK NO ST DATE
1 2 7-Dec-09 4 11/23/2009
1 3 14-Dec-09 1 11/30/2009
3 1 2-Dec-09 2 12/7/2009
4 2 10-Dec-09 3 12/14/2009
5 4 27-Nov-09
4 2 10-Dec-09
The second table on the right is in G1 t o H5
in my excel version and according to my regional set up the dates in column H have to be filled as excel data that is m/d/yy and not as given by you. Note this change.


the fomula in C2 is

=VLOOKUP(B2,$G$2:$H$5,2,FALSE)+A2-1

copy C2 down