K
KRiffe
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?
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?