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

08-15-2014, 12:06 AM

macropod

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

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

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 12:02 AM.