1

Topic: Amount of days between the specified dates having on every month

Asked to help with the formula "for count of an amount of days between the specified dates having on every month"
Made a draft copy, but it does not consider incomplete months
Still like it is possible by means of MINES/MAKS or array formulas?

2

Re: Amount of days between the specified dates having on every month

LeCrunch,

3

Re: Amount of days between the specified dates having on every month

LeCrunch;
=IF (AND (C$3 <$B4; D$3-1> $A4); MIN ($B4-C$3; D$3-1$ A4; D$3-C$3))
It is necessary only  in the counter of days to fasten.

4

Re: Amount of days between the specified dates having on every month

Thx for MINES!)