Microsoft Office Forums - View Single Post - [Solved] Formula that determines multiple occurances within a pre-determined time period

Thread: [Solved] Formula that determines multiple occurances within a pre-determined time period

View Single Post

Old

01-09-2018, 11:55 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Does this work?

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

Reply With Quote