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.
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- The page cannot be displayed. (80710a06) ✓ - Laptop Forum
- How to find specific words on a page - Guide
- The page cannot be displayed. (80710a0 - Internet Explorer & Edge Forum
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