Hello,

I am trying to create a cell which displays specific text depending on the date range chosen.

I am attempting the following formula/function but cannot get it to work. When I submit the formula, the cell says, "THIS IS OVER 90 DAYS" so appears to be working, however, it does not adjust to anything other than that text.

=IF(H13<TODAY()+90,"THIS IS OVER 90 DAYS",IF(H13<TODAY()+30,"Send 30 day reminder",IF(H13<TODAY()+10,"Send 10 Day Reminder",IF(H13<TODAY()+5,"Send 5 Day Reminder"))))

Can anyone please help?

Thanks

chris