Workday in Excel
Workday
in Excel
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..
Microsoft
Excel Function
=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.
Content
Data
StartDate
|
Days
|
Result
|
|
1-Jan-16
|
28
|
42410
|
=WORKDAY(D4,E4)
|
2-Jan-16
|
28
|
10-Feb-16
|
=WORKDAY(D5,E5)
|
Workday in Excel
Reviewed by Rupesh
on
01:35
Rating:
No comments: