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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If over 60, then show all detail 1
Age Date Between Two Dates to Return Value as 30, 60, 90 day 4
How to implement two shifts per day with multiple teams 0
How to add 30, 60 and 90 days to date and calculate deepening disc 5
Conditional Formating for dates beyond 30, 60, 90 to be high light 3
Calculate 60 days from Start Date - including weekends 5
30, 60 or 90 day averages 3
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1

Top