Date Population

[wrightyrx7]

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

[Bob Phillips]

A4: =A3-(WEEKDAY(A3,2)-1)
A5: =IF(A4="",A3+3,IF(WEEKDAY(A4)=6,"",A4+1))

copy A5 down.

[wrightyrx7]

Thank you for your reply, another quick one. Is there a formula that could work out the first WORKING day of the month. Mon-Fri being the working week?

Thanks again
Chris

[Bob Phillips]

Yep.

=WORKDAY(A3-DAY(A3),1)

[wrightyrx7]

Ignore this last message i used

=WORKDAY(A3-DAY(A3),1)

which seems to do the job.

Regards
Chris

[wrightyrx7]

LOL think we sent reply at the same time.

Thanks though :)