Thread: [Solved] Need cell to return NULL if there is a formula in referenced cell
View Single Post
 
Old 10-10-2023, 12:30 PM
wsnow wsnow is offline Windows 10 Office 2019
Novice
  
Join Date: Sep 2023
Posts: 24
wsnow is on a distinguished road
Default Need cell to return NULL if there is a formula in referenced cell
=IF(ISBLANK($T2),"", MAX(0,$T2-TODAY()))

This formula reads column T for a date and counts down to Zero where it stops. There is a formula underlying the date in column T so that even when there is no date, Excel doesn't read the cell as "blank" because of the formula. I've tried ISERROR but I think I got my syntax wrong. I need this formula to return NULL when there is no date in column T.
Thanks.
Reply With Quote