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
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