formula "next month same day"
 

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

formula "next month same day"
 

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

formula "next month same day"
 

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