Excel 2000

J

j0white

I have a spreadsheet in Excel 2000 that I'm using to track milestones in a
Project. I have a project start date and I need to add business days to a
specific date or cell in the spreadsheet. I now how to add days to a cell. I
have done that on some milestones dates. But on a few dates, I need to add
workdays/weekdays to a date.
 
P

Paul Sheppard

j0white said:
I have a spreadsheet in Excel 2000 that I'm using to track milestones i
a
Project. I have a project start date and I need to add business days t
a
specific date or cell in the spreadsheet. I now how to add days to
cell. I
have done that on some milestones dates. But on a few dates, I need t
add
workdays/weekdays to a date.
Click to expand...

Hi j0white

You could use the WORKDAY function, if the project start date was i
cell A1 and you wanted to add 6 working days the formula would be
=WORKDAY(A1,6)

If there are holiday dates or dates you do not want included th
formula would become =WORKDAY(A1,6, {38679}), where 38679 is the seria
number of the date, you can find the serial number of the data by typin
in a date and formating it as General

Alternatively you could have a list of holiday or dates you wan
excluded and use the cell references of the dates instead, in whic
case the formula would look like this =WORKDAY(A1,6,Z1
 
R

Roger Govier

Hi

Try
=WORKDAY(A1,6,A5:A15)

This would add 6 weekdays to the date in A1, taking into account holiday
dates located in cells A5:A15. You could name the range of dates A5:A15 as
holidays then use
=WORKDAY(A1,6,holidays)

Regards

Roger Govier
 
J

j0white

I tried the following with no luck.

Formula Error Message
=WORKDAY(E6,6) #NAME?
=WEEKDAY(E6,6) #NUM!

I tried Weekday because it is listed in Paste Function as a Function Name.
Do you have any other suggestions? I would appreciate it. Thanks.
 
D

Dave Peterson

Look at excel's help for =Workday() and you'll see that it's part of the
analysis toolpak. Help will even tell you how to install that addin.

If you look at excel's help for =weekday(), you'll see the support parms.


I tried the following with no luck.

Formula Error Message
=WORKDAY(E6,6) #NAME?
=WEEKDAY(E6,6) #NUM!

I tried Weekday because it is listed in Paste Function as a Function Name.
Do you have any other suggestions? I would appreciate it. Thanks.
Click to expand...
 
Top