Values based on Date in 2 columns

[murexcel]

Hi, I'm trying the below formula for changing the start & stop text based on dates. What we want is that if the start date is tomorrow, it should show START. If the stop date is tomorrow, it should show STOP today.

Some times we enter dates 1 week prior & we want the data to change a day prior.

SAMPLE DATA-ETAF-2.xlsx
	A	B	C
1	Start Date	Stop Date	Meal 1 - ORDER
2	01-05-23	07-05-23	STOP
3	01-06-23	01-08-23	STOP
4	04-05-23	05-05-23	STOP
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=IF(AND(TODAY()>=$A2-1,TODAY()<$B2-1),"START", "STOP")

Appreciate the help.

 

[Skybluekid]

Question being, what should it say if both conditions are false?

 

[murexcel]

It should show a message highlighted CHECK DATE

 

[Skybluekid]

Try

=IF(TODAY()+1=A2,"START",IF(TODAY()+1=B2,"STOP","CHECK DATE"))

 

[murexcel]

If you put date for tomorrow it still shows CHECK DATE, but it should be STOP.

SAMPLE DATA-ETAF-2.xlsx
	A	B	C
1	Start Date	Stop Date	Meal 1 - ORDER
2	01-05-23	08-05-23	CHECK DATE
3	01-06-23	01-08-23	STOP
4	04-05-23	05-05-23	STOP
Sheet1

Cell Formulas
Range	Formula
C2	C2	=IF(TODAY()+1=A2,"START",IF(TODAY()+1=B2,"STOP","CHECK DATE"))
C3:C4	C3	=IF(AND(TODAY()>=$A3-1,TODAY()<$B3-1),"START", "STOP")

 

[murexcel]

Main purpose is that the value should show START between the Start Date & Stop Date, else it should show STOP. But it should reflect a day prior.

If the start date is greater than the stop date or vice versa, it should show CHECK DATE.

 

[Skybluekid]

Main purpose is that the value should show START between the Start Date & Stop Date, else it should show STOP. But it should reflect a day prior.

If the start date is greater than the stop date or vice versa, it should show CHECK DATE.

In my opinion, what you have stated does not make sense. In the above, the first line is logical and the formula that drives that is the one that you originally posted. However, the second line will always show "Check Date", as you will need to put this "IF" statement in first, so the formula will stop if this strue, which it will always be.