Wow, more responses that I expected.

Thanks a lot guys - I didn't realise that there was a MONTH function that
would have made it easier!

"Sandy Mann" wrote:

Matt,

If I understand you correctly in G8 enter the formula:

=IF(MONTH(F8+7)=MONTH(C8),F8+7,"")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Matt_hull1979" wrote in message
...
I am designing a new overtime form and our overtime policy states that each
form must be from the First Monday of the month until the week commencing
on
the last Monday of the month.

I would like to have it so that if you enter the start date of the
overtime
form (in field B2) at the top of the page the 5 columns all headed with
dates
are automatically populated.

This is easy enough with the first column (C8) =B2, and all later dates
=C8+7, =D8+7, etc.

The problem is...

If I enter the start period as yesterday 4/9/2005 (sorry, I'm English, so
may have the date the wrong way round for the Americans!) then the final
Monday of the 5 week period will be 2/10/2005, in the following month. In
this case, instead of automatically updating to 2/10/2005, I would like
the
field to remain blank and only 4 of the columns to be headed.

Is this possible?

Many thanks in advance!