![]() |
#5
|
||||
|
||||
![]()
=IF(LEN($T2)<2,"", MAX(0,$T2-TODAY()))
It's <2 in the formula because the formula for most cells in column T is: =IF(ISBLANK($Q2)," ", DATE(YEAR($R2),MONTH($R2),(DAY($R2)-60))) where there is a single space between the double quotes. If you had nothing between the double quotes the formula would be a more traditional: =IF(LEN($T2)<1,"", MAX(0,$T2-TODAY())) BTW, consider shortening the formula in column T to: =IF(ISBLANK($Q2),"", $R2-60) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
I want my formula to result in zero if referenced cell = 0, otherwise calculate | Daronovitz | Excel | 2 | 12-21-2022 11:44 AM |
Filling a formula down a column where only one cell value referenced changes? | sakurasanta86 | Excel | 1 | 08-27-2018 03:23 AM |
![]() |
takamaz | Excel | 2 | 03-11-2018 08:56 AM |
Random cell return using vlookup formula | mattbeaves | Excel Programming | 3 | 05-22-2017 04:38 AM |
![]() |
Anyroad | Excel | 4 | 09-15-2015 04:13 PM |