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 Contributor Last seen December 27, 2022 - Apr 18, 2016 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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 search for a specific word on a webpage - Guide
- What is the function of a hard drive - Guide
- How do i find a specific video on youtube - Guide
- The page cannot be displayed. (80710a0 - Google Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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
