I am using the WORKDAY function and occasionally the value it returns is
#NAME?. When it does this I can go to Add-Ins, uncheck the Analysis Tool Pak
check box, then recheck the box and the WORKDAY funtion works again. Later,
perhaps the next time I open the spreadsheet or perhaps in a few days it will
quit working until I toggle the Tool Pak again.

Why does it occasional quit working? The date in the WORKDAY function is a
cell in a pivot table. Could that be the problem?

Thanks for your help.

David