IF Blank then perform formula calculation if not perform different formula.

[trentq]

Hi all, hoping this is possible and for some help

I would like column U to calculate the number of days since the date entered in column R and today UNLESS there is a date in column V, in which case we want column U to equal the number of days between dates in column R & V.

Hope this makes sense.

Thanks

 

[AlanY]

try

=if(isblank(V1),today()-R1,R1-V1)

 

[trentq]

Thank you, that is perfect. One additional thing - is there a way to return blank (instead of 43545) if there is no value in R?

 

[MimiM]

Try

=IF(NOT(ISBLANK(R1)),IF(ISBLANK(V1),TODAY()-R1,R1-V1),"")

 

[trentq]

Perfect, thank you very much!