Calculate amount of days per month from a given timerange
I am wondering whether someone can help me with a formula(s) to calculate the amount of days per month when given a certain timerange.
If I have
in cel A1 the date 15-02-2019
In cel B1 the date 07-04-2019. (given dates should be included in the calculation!)
As a result I would like see that there are
- 14 days in February
- 31 days in March and
- 7 days in April.
Who will help me out? Looking forward to hearing from you.
Regards. Yde
|