If cell is true return nothing

[packie]

Hi,

Col B = contains dates in the range

Col L = contains dates in some cells in the range

At the moment I am using the following formula:

=TODAY()-B12

Now I want to put a condition into the formula.

Whenever a cell in col L contains a value then return nothing

Thank you for taking an interest.

[#2 · Accepted solution]

@packie Perhaps this:

=IF(ISBLANK(L12),TODAY()-B12,"")