Re: Previously solved problem "If TODAY greater than......."Message" - HELP!!"
The formula has stopped working since I came back to work after the New Year (is this relevant?) The whole list under the "Message" column (H) now permanently shows the error #NAME? whether or not dates have been entered (in F and/or G). As far as I am aware nothing has changed (except 2005 - 2006) Any ideas please?
NETWORKDAYS requires the Analysis Toolpack to be installed - is it?
On the Tools menu, click Add-Ins. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. Tip If Analysis Toolpak is not listed, click Browse to locate it.
If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it. Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
I have checked and the formula works for me so it is nothing tom do with the change of year.