Count the common time period (month) between two date period of time

		Microsoft Office Forums > Microsoft Excel > Excel
Count the common time period (month) between two date period of time

FAQ

Thread Tools

Display Modes

08-14-2014, 11:46 PM

Barni

Windows 7 64bit Count the common time period (month) between two date period of time

Office 2010 64bit

Novice

Join Date: Aug 2014

Posts: 4

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 PM.