Microsoft Office Forums

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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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
__________________
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
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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe you can use the attached.
Attached Files
File Type: xlsx TimeRange.xlsx (11.8 KB, 13 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:11 AM.


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