help with if statement

[pkohli]

Hi,

I have written a formula - =IF(BO2<>"EOL - TBD",(BO2-TODAY()),"EOL - TBD")

Column BO have dates in mmm-yy format and where dates are not decided it appears as EOL - TBD.

I have to write a formulas that subtract today's date from BO date and where it appear as EOL - TBD it should display EOL - TBD.

Since I am using date function it is somehow unable to display EOL - TBD and giving #Value! error.

Please help with formula.

Thanks

 

[DonkeyOte]

change to

=IF(ISNUMBER(BO2),BO2-TODAY(),BO2)

 

[pkohli]

it worked! Thanks a ton!