5 days from now (revisited)

[johnfli]

Ok, I was using the one formula that was provided here
=if(day(a1)=1,a1+4,a1+6) and it seems to work sometimes.

if the date is
11/1/04 it gives 11/5/04 Correct
11/1/04 it gives 11/5/04 Correct
11/1/04 it gives 11/5/04 Correct
11/1/04 it gives 11/5/04 Correct

 

[johnfli]

oops, hit send before I was done., let me finish what I was saying.

Ok, I was using the one formula that was provided here
=if(day(a1)=1,a1+4,a1+6) and it seems to work sometimes.

if the date is
11/1/04 it gives 11/5/04 Correct
11/2/04 it gives 11/8/04 Correct
11/3/04 it gives 11/9/04 Correct
11/4/04 it gives 11/10/04 Correct
11/5/04 it gives 11/11/04 Correct
11/6/04 it gives 11/12/04 Correct
11/7/04 it gives 11/13/04 wrong should be 11/12/04
11/8/04 it gives 11/14/04 wrong should be 11/12/04
11/9/04 it gives 11/15/04 Correct
11/10/04 it gives 11/16/04 Correct
11/11/04 it gives 11/17/04 Correct
11/12/04 it gives 11/18/04 Correct


I looked into teh first reply, and wasn't able to find "Analysis Tool Pak"
as suggested with

"Look at the WORKDAY function. You need to install the Analysis Tool Pak to
use
it. All is explained in Help."


What do I need to do to fix this?

 

[Fernando Gomez]

You are probably confuse with the formula there is WEEKDAY and DAY:
WEEKDAY Number the days from 1 to 7 Sunday to Saturday
Day Numbes the day of the month, Example 11/7/04 Day(11/7/04) = 7, bu
WEEKDAY(11/7/04)=1.

 

[Ron Rosenfeld]

I looked into teh first reply, and wasn't able to find "Analysis Tool Pak"
as suggested with

"Look at the WORKDAY function. You need to install the Analysis Tool Pak to
use
it. All is explained in Help."


What do I need to do to fix this?

What happened when you followed the directions in HELP for WORKDAY to install
the Analysis Tool Pak.

Do you have a Tools item on the main menu bar?
Do you have an Add_Ins selection under Tools?

If you have that, and Analysis ToolPak is not listed as one of the available
add-ins, then you may need to reinstall Excel from your original CD.


--ron