Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:32 PM.


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