ISBLANK or IF statements

[EBoudreau]

I’m looking to calculate a cell two different ways depending on whether or not it’s blank. For example: if cell B1 is blank, I want to calculate “Today()-A1”. If it is not blank, I want to calculate “B1-A1”.

How would I put that into a formula that works? I can’t make it work in an IF Statement.

 

[snjpverma]

Try this

=IF(B1,B1-A1,TODAY()-A1)

 

[EBoudreau]

Try this

=IF(B1,B1-A1,TODAY()-A1)

That worked perfectly! Thanks!

Not sure where I was going wrong. It’s working now though so that’s all that matters!

 

[snjpverma]

thanks for the update. glad it worked