Microsoft Office Forums Calculate amount of days per month from a given timerange
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-29-2019, 07:29 AM
 Yde1203 Windows 10 Office 2016 Novice Join Date: Jul 2018 Posts: 4
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
#2
04-29-2019, 07:51 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,396

Could you please post a sample sheet ( no pics) showing what your end layout should be ?
Also have a look at the DATES function
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
#3
04-30-2019, 09:21 PM
 xor Windows 10 Office 2016 Expert Join Date: Oct 2015 Posts: 1,029

Maybe you can use the attached.
Attached Files
 TimeRange.xlsx (11.8 KB, 8 views)
#4
05-02-2019, 08:13 PM
 Yde1203 Windows 10 Office 2016 Novice Join Date: Jul 2018 Posts: 4

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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post ddhawks Excel 2 07-12-2016 11:48 PM melvin1942 Excel 13 05-22-2016 04:03 PM sp1d3r69 Excel 3 01-26-2015 07:35 AM teapea21 Outlook 1 07-31-2014 09:05 AM shilabrow Excel 5 06-26-2014 12:17 AM

All times are GMT -7. The time now is 05:08 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top