In Cell A1 put Jan 31. In Cell A2 add this formula...
=EOMONTH(A1+1, 0)

You can drag this formula down and it will give you the last day of the
following month. You need to install the Analysis Toolpack to use this
formula if you have not already.

Tools - Addins - Analysis Toolpack

--
HTH...

Jim Thomlinson


"Ubi bene .." wrote:

Hi Wizards,
I struggled a lot trying to find out formula returning "next month same day"
but also considering "next month END" i.e. A1: 29-Feb-04, A2: 31-Mar-04, A3:
30-Apr-04.
I found a way a month ago playing with the date functions (I think) but lost
the file and am not able to reproduce the formula now.
Anybody?..