how to make formula to get past due 30-60-90 days

R

Roger Govier

Hi

=IF(duedate<today(),"",IF(duedate-Today()<=30,"30
Days",IF(duedate-today()<=60,
"60 Days",IF(duedate-Today()<=90,"90 days","greater than 90 days"))))
 
Top