General discussion

Locked

Excel: Due Date

By figuerca ·
Is there a formula that will give me the date a project will be finished? Let me explain. I have a project that is given to me today, and I have 123 WORKING days to complete. How can I get the DUE Date? (Obviously Saturdays, Sundays and Holydays do not count)

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Excel: Due Date

You can find out a lot about dates at
www.cpearson.com/excel/DateTimeWS.htm
I think what you're looking for is the WORKDAY function.

You need to have the Analysis Toolpak installed
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.


WORKDAY
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

Syntax

WORKDAY(start_date,days,holidays)

Important Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Start_date is a date that represents the start date.

Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

Holidays is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums