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?..

Same day as when? Today?

=DATE(YEAR(A1),MONTH(A1)+1,DAY(TODAY()))

if you want the last day of the next month use

=DATE(YEAR(A1),MONTH(A1)+2,0)


--

Regards,

Peo Sjoblom



"Ubi bene .." wrote in message
...
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?..

On Wed, 19 Oct 2005 14:11:04 -0700, "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?..


=DATE(YEAR($A$1),MONTH($A$1)+COUNT($A$1:A1),MIN(DA Y($A$1),
DAY(DATE(YEAR($A$1),MONTH($A$1)+COUNT($A$1:A1)+1,0 ))))

With the first date in A1, enter the formula in A2 and copy/drag down as
needed.


--ron