Turns out I don't need the if scenario. so these simple ones worked great,
thanks.

"macropod" wrote:

Hi nibbana,

For A1/B1:
=DATE(Year(A1),MONTH(A1)+1,1)
For A2/B2:
=DATE(Year(A2),MONTH(A1)+2,0)

--
Cheers
macropod
[MVP - Microsoft Word]


"nibbana" wrote in message ...
Here's my data:

A B
1 1-Jun-08 1-Jul-08
2 30-Jun-08 31-Jul-08

I need a formula in B1 and B2 that will:

If col A date is first day of month then return first day of next month; or
If col A date is last day of month then return last day of next month.

Thanks!