Formula to check days of the month and display only weekdays
Closed
Middo
-
17 Apr 2016 à 16:14
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Apr 2016 à 11:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Apr 2016 à 11:52
Related:
- The workday function displays the date of the weekday a specific number of weekdays past a starting date.
- What is the function of a hard drive - Guide
- How do i find a specific video on youtube - Guide
- What is the function of a network card - Guide
- Internet explorer cannot display the webpage - Guide
- Function of insert key - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
18 Apr 2016 à 11:52
18 Apr 2016 à 11:52
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
