in the 5th week (A5)

=IF(MONTH(A4+7)=MONTH(A4),A4+7,"")

in the next first week

=IF(A5="",A4+7,A5+7)

Hope this helps

--

Lisa Wrote:
I am trying to fill in weekly dates from entering the first Monday in
April,
which I can do by A1+7....but I have the months arranged in blocks of 5
and
want the cell to remain blank if there is only 4 weeks in that month
and put
the date in the box below it.

Any ideas please?

Regards,
Lisa


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535305