Formula that determines multiple occurances within a pre-determined time period

		Microsoft Office Forums > Microsoft Excel > Excel
Formula that determines multiple occurances within a pre-determined time period

01-09-2018, 11:55 AM

NBVC

Windows 10 Formula that determines multiple occurances within a pre-determined time period

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Does this work?

=IF(AND(C3="Professional",C2="Professional",A3=A2, B3-B2<=365),"Y","")

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a formula to count all occurances of HH but multiply by 0.5 first	stupidgirl	Excel	6	06-14-2016 03:50 PM
Count the common time period (month) between two date period of time	Barni	Excel	6	08-15-2014 07:52 AM
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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 PM.