Nested If Date function


#1

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.


#2

@Jennie_Patterson Maybe something like this:

Alerts

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()))