The formula =EOMONTH(B46,-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 B46. 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 B46 yet.
Thanks.
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 B46 yet.
Thanks.