Course Content

  • Formulas

Course Content


The YEAR function in Excel is quite simple to use, and you should have no trouble utilising it in your date calculations: The formula =YEAR(A2) yields the year of a date in cell A2. The year of the supplied date is returned by =YEAR("20-May-2015").

In the worksheet with Auto Fill Options, just fill in the weekdays:

  • Drag the fill handle to the desired end dates, as shown in the screenshot:
  • Then, in the right-hand corner, click the Auto Fill Options button and select the Fill Weekdays option, as seen in the screenshot:
  • As you can see, the spreadsheet is now solely filled with weekdays.

Based on an offset number you supply, the Excel WORKDAY. INTL function takes a date and produces the nearest working n days in the future or past. WORKDAY. INTL, unlike WORKDAY, allows you to choose which days are deemed weekends (non-working days).

  • Place your cursor within the cell where the formula will be stored.
  • Specify =networkdays
  • as the second type. Then, wrapped in "', type the first date in the range. For instance, "4/6/2020."
  • Then type a comma followed by the range's end date encased in quotes.
  • Close your eyes and press the enter key.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere