Excel 2020: Use WORKDAY.INTL for a Work Calendar - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Wednesday, July 29, 2020

Excel 2020: Use WORKDAY.INTL for a Work Calendar

Excel 2020: Use WORKDAY.INTL for a Work Calendar

While NETWORKDAYS calculates the work days between two dates, the WORKDAY function takes a starting date and a number of days, and it calculates the date that is a certain number of work days away.
One common use is to calculate the next work day. In the following figure, the start date is the date on the previous row. The number of days is always 1. To generate a class schedule that meets on Monday, Wednesday, and Friday, specify a weekend of "0101011".
You want to fill dates for Monday, Wednesday and Friday. Type the first date in A2. Below that, use =WORKDAY.INTL(A2,1,"0101011"). This says to start from the date in A2, go out 1 day, based on a work week where Tuesday, Thursday, Saturday and Sunday are the weekends.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment