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

trentq

New Member
Joined
Jun 19, 2012
Messages
4
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,191
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try

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

trentq

New Member
Joined
Jun 19, 2012
Messages
4
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,461
Messages
5,528,939
Members
409,848
Latest member
Blomsten
Top