Thread: Workday Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Workday Formula

Is the Analysis Toolpak enabled still? (ToolsAddins)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Shannon" wrote in message
...
Hi,
I have the workday formula in one of my spreadsheets and it seems that
just
recently it has stopped working and I cannot figure out why.
Cell A2: Users enter a date (dd/mm/yyyy)
Cell A3: Here is the WORKDAY formula

I want A3 to show the date 3 business days after A2. Now I have
=WORKDAY(A2,L3) where L3 refers to a cell with the number 3 in it. Used
to
work, now it doesnt.

Any help would be wonderful.

Thanks!
Shannon