Workday Formula in Microsoft Excel
Tuesday, Mar 31
commerce curve online accounting course

Workday Formula in Microsoft Excel

The workday formula in Excel is an important function in an Excel spreadsheet, it computes the due date of a particular task based on starting date and specified number of days after considering all the weekends and holidays. This function can be used to compute invoice due dates, expected delivery dates, total no. of days of work done and several other timeliness. This post will demonstrate how to use Workday function in an Excel spreadsheet.

The formula for workday function is as follows:

  • =Workday(Start_date, Days, [Holidays])

Where,

  • Start_date = Starting date of the project
  • Days = No. of days it will take to complete the project
  • Holidays = List of non-working days i.e holidays (optional i.e. it can be ignored)
The above mentioned formula can be explained with the help of following example.

Workday function – Without Holidays

Here we will explain how to use the workday formula in Excel without holidays.

Blue Dart has received a courier order on 24th December 2019, the same is expected to be delivered in 7 working days. Supposing there are no official holidays in between, the due date of this delivery can be calculated as follows:

Since December 28, 2019 is a Saturday and December 29, 2019 is a Sunday the same are not included by the formula while calculating the due date i.e. January 02, 2020

Workday function – With Holidays

Blue Dart has received a courier on December 24, 2019, the same will be delivered in 7 working days. However, Due to Christmas and New Year, December 25, 2019, December 31, 2019 and January 1, 2020 are public holidays:

Since December 25, 2019, December 31, 2019 , and January 1, 2020 are public holidays and December 28, 2019, December 29, 2019 comes over the weekend, they push out the workdays. The 7th subsequent workday to December 24, 2019 January 07, 2020.

Please note, the Workday formula can also be used for determining past dates, by simply mentioning the number of days with a negative sign (“-“).

I hope that helps. Please leave a comment below with any questions or suggestions.

Thank you!

0 0 votes
Article Rating
guest
0 Comments
Inline Feedbacks
View all comments

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.