PrabasTech

Excel Formula WorkDay & WorkDay.INTL

Excel Functions - Workday & Workday.INTL()

It returns a date that is the indicated number of working days before or after the starting date. It gives the end date by excluding weekends and any dates listed as holiday.

இது ஒரு தேதிக்கு முன்னதாக அல்லது அதற்குப் பிறகு குறிப்பிடப்பட்ட வேலை நாட்களின் சரியான தேதியை வழங்குகிறது. இது வார இறுதி நாட்களையும் விடுமுறையாக பட்டியலிடப்பட்ட எந்த தேதிகளையும் தவிர்த்து இறுதி தேதியை அழகாக வழங்குகிறது.

This tutorial explains the various methods of calculating a date:

இந்த டுடோரியல் ஒரு தேதியைக் கணக்கிடுவதற்கான பல்வேறு முறைகளை சொல்லியிருக்கிரோம்:

  1. Manual date calculation
  2. = WORKDAY(start_date, days, [holidays]) function by considering the weekends and ignoring holidays
  3. = WORKDAY(start_date, days, [holidays]) function by considering the weekends and holidays
  4. = WORKDAY.INTL(start_date, days, [weekend], [holidays]) function by considering the optional weekends and ignoring holidays.

Arguments of these formulas:

  • Start_date Required. A date that represents the start date.
    Days Required. 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 Optional. 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.
  • Weekend Optional. Indicates the days of the week that are weekend days and are not considered working days. Weekend is a weekend number or string that specifies when weekends occur.

Download Excel

for Practice

If you watch and understand the entire tutorial along with the practice file, it is a great time saver in such scenarios. 

I hope you understood and practiced the entire concept. Thanks for your time for reading this article.

Want to receive weekly insights  tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?