Excel v.2003 - An alternative formula for EOMONTH (v.2007)

[Henrique Carvalho]

Hi guys!


I use the 2003 version of MS Excel. Altough, i need the use of formula (EOMONTH) in v.2007. Is there any way i can make a alternative formula in v.2003 to simulate the formula (EOMONTH) in v.2007?


Thanks for your Help!

 

[Hui]

Henrique

In all versions up to and including Excel 2003

Go to Tools, Addins and select the Analysis Toolpack option

After Excel updates itself EOMONTH will be available

 

[oldchippy]

Hi,


If you want an alternative without the ATP then this will give the same result


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

 

[Henrique Carvalho]

Thanks Guys!


That helped me a lot.

 

[Hui]

@OldChippy

Thats works for the first Cell B1

But from C1 across it needs to be changed to

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

 

[oldchippy]

@Hui,


Your absolutley right Hui, I didn't know that Henrique required a row of dates??

 

[Henrique Carvalho]

The main objective was indeed a row of dates, but when i saw oldchippy formula i got the idea and then modified it to match others cells.


Thanks again for yours support.