wrightyrx7
03-13-2012, 08:50 AM
Hi all,
I have a table with dates in column A like the following:-
A3 = MASTER DATE
A4 = Mon dd mmm
A5 = Tue dd mmm
A6 = Wed dd mmm
A7 = Thu dd mmm
A8 = Fri dd mmm
A9
A10 = Mon dd mmm
A11 = Tue dd mmm
A12 = Wed dd mmm
A13 = Thu dd mmm
A14 = Fri dd mmm
A15
A16 = Mon dd mmm
A17 = Tue dd mmm
A18 = Wed dd mmm
A19 = Thu dd mmm
A20 = Fri dd mmm
A21
A22 = Mon dd mmm
A23 = Tue dd mmm
A24 = Wed dd mmm
A25 = Thu dd mmm
A26 = Fri dd mmm
I was wondering if i can put the master date in and it will populate the first monday and input the dates going down until the last day of the month?
Anyone?
Thanks in advance
Chris
I have a table with dates in column A like the following:-
A3 = MASTER DATE
A4 = Mon dd mmm
A5 = Tue dd mmm
A6 = Wed dd mmm
A7 = Thu dd mmm
A8 = Fri dd mmm
A9
A10 = Mon dd mmm
A11 = Tue dd mmm
A12 = Wed dd mmm
A13 = Thu dd mmm
A14 = Fri dd mmm
A15
A16 = Mon dd mmm
A17 = Tue dd mmm
A18 = Wed dd mmm
A19 = Thu dd mmm
A20 = Fri dd mmm
A21
A22 = Mon dd mmm
A23 = Tue dd mmm
A24 = Wed dd mmm
A25 = Thu dd mmm
A26 = Fri dd mmm
I was wondering if i can put the master date in and it will populate the first monday and input the dates going down until the last day of the month?
Anyone?
Thanks in advance
Chris