Formula to check days of the month and display only weekdays
Closed
Middo
-
Apr 17, 2016 at 04:14 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 18, 2016 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 18, 2016 at 11:52 AM
Related:
- The workday function displays the date of the weekday a specific number of weekdays past a starting date.
- How to start a listening party on spotify pc - Guide
- The page cannot be displayed. (80710a06) ✓ - Laptop Forum
- The page cannot be displayed. - Google Forum
- What are the key functions of the supportassist for home pcs? - Download - Cleaning and optimization
- Function of insert key - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 18, 2016 at 11:52 AM
Apr 18, 2016 at 11:52 AM
Hi Middo,
The following formula will check the workdays in January 2016 and return the next workday (the first workday in February), where weekend is Friday and Saterday:
=WORKDAY.INTL(DATE(2016,1,1),NETWORKDAYS.INTL(DATE(2016,1,1),DATE(2016,2,1),7),7)
Best regards,
Trowa
The following formula will check the workdays in January 2016 and return the next workday (the first workday in February), where weekend is Friday and Saterday:
=WORKDAY.INTL(DATE(2016,1,1),NETWORKDAYS.INTL(DATE(2016,1,1),DATE(2016,2,1),7),7)
Best regards,
Trowa
