Microsoft Office Forums - View Single Post - Formula for looking at 1 cell with a date and then comparing it to four date ranges

Thread: Formula for looking at 1 cell with a date and then comparing it to four date ranges

View Single Post

Old

10-27-2017, 12:09 PM

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

Maybe?

Code:

=IF(M4955<=DATE(2014,6,30),0,IF(AND(M4955>=DATE(2014,7,1),M4955<=DATE(2015,6,30)),1,IF(AND(M4955>=DATE(2015,7,1),M4955<=DATE(2016,6,30)),2,IF(AND(M4955>=DATE(2016,7,1),M4955<=DATE(2018,6,30)),3,""))))

Reply With Quote