Mar 06 2020 06:18 AM
Hi All
I have another question I seem to stuck I'm doing a sheet
Outstanding | Dates |
> 6 months | 07/01/2020 |
Between 3 - 6 Months | 14/01/2020 |
Between 3 - 6 Months | 17/01/2020 |
< 3 months | 20/01/2020 |
< 3 months | 23/01/2020 |
what I want to do is when to input the "date" into the "Outstanding" cell I just want it to return "> 6 months" for example
Mar 06 2020 02:03 PM
Mar 06 2020 02:13 PM
Mar 06 2020 02:37 PM
If so, try this formula below and find it in the attached file:
=IF(B2-DATE(LEFT(C2,4),RIGHT(C2,2),1)>160,"> 6 months",
IF(B2-DATE(LEFT(C2,4),RIGHT(C2,2),1)<90,"< 3 months",
"Between 3 - 6 months"))
Hope that helps