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

Could you please post a sample sheet ( no pics) showing what your end layout should be ?
Also have a look at the DATES function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Maybe you can use the attached.

Attached Files

TimeRange.xlsx (11.8 KB, 15 views)

Xor: thank you very much. Exactly what I needed.
Regards.
Yde