![]() |
|
#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) |
|
|
Similar Threads
|
||||
| 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 |
Filling a formula down a column where only one cell value referenced changes?
|
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 |
Formula to return next non-blank cell in a range
|
Anyroad | Excel | 4 | 09-15-2015 04:13 PM |