Is question - Subtracting number of dates

[slhope23]

I have three columns: I am trying to say:

If column B2 has a date then it should be subtracted by A2 but if B2 does not have a date then it should be subtract by today

I know the formulas separately but i cant seem to put them together

=TODAY()-A2))
= If(Isblank(B2), " ", A2-B2)

 

[Fluff]

Hi & welcome to MrExcel
Is this what you mean
=IF(B2="",TODAY()-A2,A2-B2)

 

[slhope23]

That is fantastic! Now is there a way to take it one step further and say If the date is after todays date then value should be 0??

 

[Joe4]

Now is there a way to take it one step further and say If the date is after todays date then value should be 0??

Just nest an IF, i.e.

[COLOR=#333333]=IF(B2>TODAY(),0,IF(B2="",TODAY()-A2,A2-B2))[/COLOR]