Microsoft Office Forums Calculate amount of days per month from a given timerange

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2019, 07:29 AM
Yde1203 Yde1203 is offline Calculate amount of days per month from a given timerange Windows 10 Calculate amount of days per month from a given timerange Office 2016
Novice
Calculate amount of days per month from a given timerange
 
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
  #2  
Old 04-29-2019, 07:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Calculate amount of days per month from a given timerange Windows 7 64bit Calculate amount of days per month from a given timerange Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,396
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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.
Reply With Quote
  #3  
Old 04-30-2019, 09:21 PM
xor xor is offline Calculate amount of days per month from a given timerange Windows 10 Calculate amount of days per month from a given timerange Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe you can use the attached.
Attached Files
File Type: xlsx TimeRange.xlsx (11.8 KB, 8 views)
Reply With Quote
  #4  
Old 05-02-2019, 08:13 PM
Yde1203 Yde1203 is offline Calculate amount of days per month from a given timerange Windows 10 Calculate amount of days per month from a given timerange Office 2016
Novice
Calculate amount of days per month from a given timerange
 
Join Date: Jul 2018
Posts: 4
Yde1203 is on a distinguished road
Smile

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate amount of days per month from a given timerange Formula For Displaying Exact Days of the Month ddhawks Excel 2 07-12-2016 11:48 PM
Formula to use a date to calculate an amount $. melvin1942 Excel 13 05-22-2016 04:03 PM
Calculate amount of days per month from a given timerange Calculate amount of entered fields sp1d3r69 Excel 3 01-26-2015 07:35 AM
Calculate amount of days per month from a given timerange Configure for 30 days, not calendar month teapea21 Outlook 1 07-31-2014 09:05 AM
Calculate amount of days per month from a given timerange Formula to divide if no of days in month is 28 shilabrow Excel 5 06-26-2014 12:17 AM


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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft