Forum Discussion
Days Calculation Between Dates by Month where start date to end date spans several months
I'm trying to work out the number of working days between two dates but split out to show how many days in each month. Have many variations to work through Start Date End Date Work days Dura...
If you are on pre-DA Excel (not 365 and not 2021) it could be
=MAX( 0, NETWORKDAYS.INTL( MAX( $A3, EOMONTH($A3, COLUMN() - COLUMN($A3) - 4) +1), MIN( $B3, EOMONTH($A3, COLUMN() - COLUMN($A3) - 3 ) ) ) )and drag it to the right