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

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

Would you care to tell us what you mean by "it has stopped working"?
What error message (if any) do you get?
What result do you get for which inputs? What result did you expect?
--
David Biddulph

"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

No its is not. I have contacted my comp admin to get them to reinstall as my
comp was just rebuilt. Thanks!

"Bob Phillips" wrote:

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

Sorry...it now just fills the cell with #NAME?
I expected it to be the date in cell A2 plus 3 business days.

Someone suggested to ensure the Analysis Toolpak is enabled (which it is
not) so perhaps that is the problem.
Thanks!


"David Biddulph" wrote:

Would you care to tell us what you mean by "it has stopped working"?
What error message (if any) do you get?
What result do you get for which inputs? What result did you expect?
--
David Biddulph

"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

Glad you've found the answer. It's always the best bet to check the
relevant functions in Excel help before you come to the group with a
question.
--
David Biddulph

"Shannon" wrote in message
...
Sorry...it now just fills the cell with #NAME?
I expected it to be the date in cell A2 plus 3 business days.

Someone suggested to ensure the Analysis Toolpak is enabled (which it is
not) so perhaps that is the problem.
Thanks!


"David Biddulph" wrote:

Would you care to tell us what you mean by "it has stopped working"?
What error message (if any) do you get?
What result do you get for which inputs? What result did you expect?
--
David Biddulph

"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