If condition with adding days

[toony]

Hi. I am trying to create a formula so that if there is 14 days or less to the estimated delivery of an item (ETA) it gives me "<14 days to del."
The below is not correct but really don't know how to approach it if you can help please.

=IF([@ETA]-today())=<14,"<14 days left","")

 

[jtakw]

Hi,

You have an extra bracket (closed the IF too soon), and wrong expression for <= (less than or equal), should be:

=IF([@ETA]-today()<=14,"<14 days left","")

 

[toony]

Hi,

You have an extra bracket (closed the IF too soon), and wrong expression for <= (less than or equal), should be:

=IF([@ETA]-today()<=14,"<14 days left","")

Hi. Actually I did see it eventually. It was very silly of me apologies for a silly question like this, really appreciate it

 

[jtakw]

You're welcome.