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.

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


j0white wrote:
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.

j0white Wrote:
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.

Hi j0white

You could use the WORKDAY function, if the project start date was in
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 the
formula would become =WORKDAY(A1,6, {38679}), where 38679 is the serial
number of the date, you can find the serial number of the data by typing
in a date and formating it as General

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=479993

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.

"Paul Sheppard" wrote:


j0white Wrote:
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.

Hi j0white

You could use the WORKDAY function, if the project start date was in
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 the
formula would become =WORKDAY(A1,6, {38679}), where 38679 is the serial
number of the date, you can find the serial number of the data by typing
in a date and formating it as General

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=479993

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.



j0white wrote:

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.

"Paul Sheppard" wrote:


j0white Wrote:
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.

Hi j0white

You could use the WORKDAY function, if the project start date was in
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 the
formula would become =WORKDAY(A1,6, {38679}), where 38679 is the serial
number of the date, you can find the serial number of the data by typing
in a date and formating it as General

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=479993



--

Dave Peterson