Add a start date from a day number and a week

Closed
Ne - Nov 21, 2009 at 12:37 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 21, 2009 at 08:50 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 21, 2009 at 08:50 PM
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