Excel end date calculation excluding weekends

  • Thread starter Thread starter Danie
  • Start date Start date
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
Click to expand...


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
 
Back
Top