The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For example, these values would be operating days, holiday’s, etc. This is explained in the examples below.

Syntax:

=WORKDAY (start_date, days, [holidays]) 
  • start_date – The starting date
  • days – Working days before or after the start_date
  • holidays (optional) – Specified non-working dates.

WORKDAY Function Usage Example

While using the function, a positive number of days calculates future dates while a negative number calculates past dates.

Usage Notes

  • The WORKDAY Function does not count the start_date as a working day
  • Saturday and Sunday are excluded by default. The WORKDAY.INTL Function lets you customize specific dates.
WORKDAY Function in Excel

Leave a Reply

CUMIPMT Function

How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return

Read More »
Scroll to Top