change true or false to text

[Directlinq]

Hi i have this formula and need to change true and false to text for both the expressions
=OR(E23<=DATE(YEAR($L$2),MONTH($L$2)+$J$2,DAY($L$2)),($L$2>E23))

what im trying to do is e23 has a static date (food sell by dates)and if that date gets within 3 month (J2) period of todays date (L2) i want it to say "warning" if e23 is equal to or older than todays date i want it to say out of date.

L2 has =today()
J2 has the number of months in it for the warning

Please help many thanks

[NBVC]

Do you mean?

=IF(OR(E23<=DATE(YEAR($L$2),MONTH($L$2)+$J$2,DAY($L$2)),($L$2>E23)),"warning","out of date")

[Directlinq]

if e23 has a date that is further into the future than j2 (months) the box is blank or says "All Good"
if e23 has a date that is less than j2 (months) into the future the box says "warning"
if e23 has a date equal to or older than todays date L2 it says "out of date"

Sorry for the confusion

[martindwilson]

=IF(E3<=TODAY(),"out of date",IF(AND(E3>TODAY(),E3<DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))),"warning","all good"))
or if number of months in J2
=IF(E3<=TODAY(),"out of date",IF(AND(E3>TODAY(),E3<DATE(YEAR(TODAY()),MONTH(TODAY())+J2,DAY(TODAY()))),"warning","all good"))
or even

=IF(E3<=L2,"out of date",IF(AND(E3>L2,E3<DATE(YEAR(L2),MONTH(L2)+J2,DAY(L2))),"warning","all good"))

[NBVC]

So if E23 had tomorrow's date, wouldn't the 2nd and 3rd condition both apply?

[Directlinq]

Brilliant thanks you very much

[NBVC]

I guess I must have misinterpreted your requirement