Thread: EOMONTH Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default EOMONTH Formula

In Excel2007 the former Analysis Toolpak functions are built-in functions. So there is no need anymore to load that Toolpak (that
is, not for using the Functions). If you happen to use a non-English version of Excel, there are a few issues, described he

http://www.rondebruin.nl/atp.htm

A good alternative for the EOMONTH(A1,0) function is:

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

Adjust the 0 in the MONTH part to your needs

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"KRiffe" wrote in message ...
| Built a worksheet in Excel 2003 which uses EOMONTH formula. The EOMONTH
| formula required the Analysis Toolpak add-in to work. That worksheet is
| stored on a network server and used by several individuals. Recently moved
| to Excel 2007 and all users accessing that worksheet have activated the
| Analysis Toolpak. When working in the file, had to rebuild the EOMONTH;
| saved the file, went back in it the next day and that formula has now turned
| to #N/A in the cell yet the date is being displayed as if the formula is
| working.
|
| Has anyone had any issues with this formula in 2007? Assuming the EOMONTH
| formula does not work - any suggestions for an alternative formula?