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, 11:47 AM

LearningMom LearningMom is offline

LearningMom is offline

LearningMom uses Windows Vista

Windows Vista LearningMom uses Office 2007

LearningMom uses Office 2007

Office 2007

Novice

The original poster

Join Date: Feb 2015

Posts: 8

LearningMom is on a distinguished road

Default

I thought I would show you the formula a have been tweaking with no success. I did get a 1 once but when I added the third formula it stopped with a error message.

=IF(AND(M4955<=DATE(2014,30,6)),0,IF(AND(M4955<=DA TE(2014,1,7),M4955<=DATE(2015,30,6)),1))

Reply With Quote