| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make formula to get past due 30-60-90 days
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.] |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating how many days past in a month from today | Excel Discussion (Misc queries) | |||
| Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
| make a cell red after 14 days | Excel Worksheet Functions | |||
| flag date within a cell after 15 days have past? | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Linear Mode
