Thread: Count the common time period (month) between two date period of time
View Single Post
 
Old 08-14-2014, 11:46 PM
Barni Barni is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Aug 2014
Posts: 4
Barni is on a distinguished road
Default
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
Reply With Quote