We don't have to work so hard on the IF test:

=IF(MONTH(A1+1)MONTH(A1),
DATE(YEAR(A1),MONTH(A1)+2,1)-1,
DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"nibbana" wrote:

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!