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
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

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
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
0