Returning 0 an if statement of reference cell is unknown

[Bexcel11]

Hi All,
In cell T7,I am trying to calculate number of weeks between 2 date columns L7-K7 unless there is no date listed in L7, therefore it calculates from AB1 which has formula =Today() so it accumulates until a date is put in L7.
The formula I have currently in cell T7 is below:
=IF(L7=“”,$AB$1-K7,L7-K7)/7
This currently works perfectly, my problem is there will be a time when both K7 and L7 dates are unknown or “blank”, when this is the case I need T7 to return a ‘0’ and/or ignore the formula.
It currently returns 6228.
Please help.

 

[mole999]

Something like

=IF(AND(K7="",L7="","",IF(L7=“”,$AB$1-K7,L7-K7)/7

it will need a closing bracket somewhere

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-when-cell-blank-post5275420.html#post5275420

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).