Excel end date calculation excluding weekends

[Danie]

I am looking for a formula to calculate the end date on a productio
schedule. We do not work on Saturdays and Sundays, and these dates mus
be excluded in working out the end date. Please refer to the attachmen
for more details

Attachment filename: end-date calculation.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53563

 

[Ron Rosenfeld]

I am looking for a formula to calculate the end date on a production
schedule. We do not work on Saturdays and Sundays, and these dates must
be excluded in working out the end date. Please refer to the attachment
for more details.

Attachment filename: end-date calculation.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=535638

Most folk, including me, won't usually open attachments.

However, what you need can probably be accomplished by the WORKDAY worksheet
function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


Syntax

WORKDAY(start_date,days,holidays)

(holidays is an optional argument to also exclude them).

See HELP for the function.


--ron