Hello,
I know that with the networkdays I can figure out the number of working days between 2 dates.
I know need something though, that calculates the number of working days in the current month with different start dates. e.g.
e.g. i would like to know how many working days we have in October between below dates:
19.06.2018 15.11.2018
03.09.2018 18.10.2018
08.10.2018 30.11.2018
01.08.2018 15.11.2018
Can anyone help me with that? VBA or functions are fine.
Thank you!
You can use the function NETWORKDAYS
=NETWORKDAYS(StartDate,EndDate,[Holidays])
... like this:
=NETWORKDAYS(MAX($D$1,A2),MIN(EOMONTH($D$1,0),B2))
see sheet. You may need ; instead of , in the formula.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks