xls - An excel formula using IS BLANK and IS NOT BLANK based on two columns

Question

I need to calc the time between two dates. If column V is blank, then look at column X; now return the difference btw the returned value (either X or V) and the date in column S.

Answer 1

Maybe

=IF(ISBLANK(V2),S2-X2,S2-V2)

In words: If cell V2 is blank, calculate S2 minus X2, otherwise calculate S2 minus V2.

Adjust to your needs.