Skip to main content

Nested If Date function

  • January 18, 2018
  • 1 reply
  • 7 views
J

I am making a template to keep track of when our fleet vehicles plates expire. I want to put a function that will warn me of any expired plates but also warn me of when plates are coming due (example…tell me when plates will expire 1 month from today).
Please help. I do not know how to write this formula.

    This topic has been closed for replies.

    1 reply

    A
    Forum|alt.badge.img+18

    @Jennie_Patterson Maybe something like this:

    IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<0,“ :stop_sign: :stop_sign: :stop_sign: Expired!!”,IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<30,“ :warning: :warning: :warning: Due within 30 days”,BLANK()))

    Terms & ConditionsAccessibility statement