#1
|
|||
|
|||
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
|
||||
|
||||
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 |
#3
|
|||
|
|||
Maybe you can use the attached.
|
#4
|
|||
|
|||
Xor: thank you very much. Exactly what I needed.
Regards. Yde |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 entered fields | sp1d3r69 | Excel | 3 | 01-26-2015 07:35 AM |
Configure for 30 days, not calendar month | teapea21 | Outlook | 1 | 07-31-2014 09:05 AM |
Formula to divide if no of days in month is 28 | shilabrow | Excel | 5 | 06-26-2014 12:17 AM |