#1
|
|||
|
|||
Count the common time period (month) between two date period of time
Can someone to help me with a formula to count the common time period (month) between two date period of time in excel.
For exemple: 1. Start date: 01-nov-2014 2 End date:31-dec-2018 1. From: 01-iul-2014 2. To: 30-iun-2015 Result in this case = 8 month Thank you so much in advance !!! Barni |
#2
|
||||
|
||||
You could use:
=DATEDIF(A1,A2,"M") Neither pair of dates in your examples has an 8-month difference, however.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
HI,
The common month period is between 01-nov-2014 - 30-06-2015 = 8 month. I have this formula and it's counting the days. I am trying to have a similar to calculate the months. d1: Startt 1 e1: End 1 g1: Start2 h1: End2 =IF(MAX(D1,G1)>MIN(E1,H1),0,(MIN(E1,H1)-MAX(D1,G1))) Regards, Barni |
#4
|
||||
|
||||
Try:
=IF(MAX(D1,G1)>MIN(E1,H1),0,DATEDIF(MAX(D1,G1),MIN (E1,H1)+1,"M"))
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thank you very much your answer but unfortunately doesn't work.
/Barni |
#6
|
||||
|
||||
That's hardly a meaningful description.
It works in my testing. Of course, I had to guess which cells the various dates were in as you haven't shared that information...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Yes. It's working!!!
I write something wrong and yes, the description was not quite enough. Thank you so much! I learned something from you Have a nice weekend! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Units worked per time period | carmang | Excel | 4 | 07-24-2014 08:24 AM |
How do I calculate planned work for a given time period | bumpui | Project | 1 | 06-04-2014 06:37 AM |
Allocation of task in certain period of time | mati2 | Project | 1 | 02-25-2012 07:59 AM |
Can't change period when adjusting actual time in Web Access | chip_saffire | Project | 0 | 10-04-2011 12:05 AM |
Add a period of time to a referenced "Time" cell? | derelyth | Excel | 4 | 03-27-2011 04:31 PM |