View Single Post
 
Old 04-29-2019, 07:29 AM
Yde1203 Yde1203 is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2018
Posts: 4
Yde1203 is on a distinguished road
Default 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
Reply With Quote