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
Hello,
Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and Saturday) and go to the next weekday of the month
Thanks a lot
Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and Saturday) and go to the next weekday of the month
Thanks a lot
Related:
- The workday function displays the date of the weekday a specific number of weekdays past a starting date.
- How to find specific words on a page - Guide
- The page cannot be displayed. (80710a06 ✓ - PS3 & PS4 Forum
- The page cannot be displayed. (80710a0 ✓ - Internet Explorer & Edge Forum
- Page cannot be displayed - Internet Explorer & Edge 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 range names. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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
