EOMONTH formula returning NAME? error

[sysmjp]

The formula =EOMONTH(A1,-2)+1 was working in a previous version of my spreadsheet to return the first day of the prior month after the date entered in cell A1. When I do "save as" to update the information, the formula returns the NAME error.

I have the required Analysis Toolpak installed. What else can create this error? The only change was "save as" and renaming the file. I did not change the date in cell A1 yet.

I'm using Excel 2003. Thanks.

 

[DonkeyOte]

I can't think of any other reason than Analysis ToolPak for the NAME error assuming there are no other functions in the formula - ie what you wrote is all that the formula contains.

As a workaround - simply use the DATE function to get your result

=DATE(YEAR(A1),MONTH(A1)-1,1)

This is a safer approach if ever distributing file(s) to other users who may not have the add-in installed and where auto installation of requisite .xla via VBA is not viable.