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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to make formula to get past due 30-60-90 days (https://www.excelbanter.com/excel-worksheet-functions/177016-how-make-formula-get-past-due-30-60-90-days.html)

ASHRAF

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

David Biddulph[_2_]

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

No question?

"ASHRAF" wrote in message
...

[This is where the question should have been, Ashraf.]

Roger Govier[_3_]

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

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

--
Regards
Roger Govier

"ASHRAF" wrote in message
...

All times are GMT +1. The time now is 10:10 PM.