Try

Tools|Addins
Select the analysis toolpak

Mike

"Cam" wrote:

Hello,

I have an Excel that was working with date formula in hundred plus row on 2
different column, then I don't know what I did, but the results on those
formula cells certainly showed "#NAME?" instead of the returned date that was
working before.
I could not figure out, I check and the formula are correct. Help Please.

=(WORKDAY($E182,-5,Holiday!$A$2:$A$109))