Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH Formula
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
eomonth | Excel Worksheet Functions | |||
EOMONTH() question | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) |