WORKDAY Function (Functions in Excel)
StartDate | Days | Result | |
1-Jan-98 | 28 | 35836 | =WORKDAY(D4,E4) |
1-Jan-98 | 28 | 10-Feb-98 | =WORKDAY(D5,E5) |
What Does It Do? |
Use this function to calculate a past or future date based on a starting date and a |
specified number of days. The function excludes weekends and holidays and can |
therefore be used to calculate delivery dates or invoice dates. |
Syntax |
=WORKDAY(StartDate,Days,Holidays) |
Formatting |
The result will normally be shown as a number which can be formatted to a |
normal date by using Format,Cells,Number,Date. |
Example |
The following example shows how the function can be used to calculate delivery dates |
based upon an initial Order Date and estimated Delivery Days. |
Order Date | Delivery Days | Delivery Date |
Mon 02-Feb-98 | 2 | Wed 04-Feb-98 |
Tue 15-Dec-98 | 28 | Tue 26-Jan-99 |
=WORKDAY(D25,E25,D28:D32) |
Holidays | ||
Bank Holiday | Fri 01-May-98 | |
Xmas | Fri 25-Dec-98 | |
New Year | Wed 01-Jan-97 | |
New Year | Thu 01-Jan-98 | |
New Year | Fri 01-Jan-99 |
0 comments:
Post a Comment