If statement returning a 0 when cell is blank

[Bexcel11]

Hi Guys,
In Cell T7 I am trying to calculate the number of weeks between two dates, L7-K7 unless there is no date in L7 there for it will calculate from AB1 where I have a formula =Today().
Currently the formula I have in T7 is below:
=IF(L7=“”,$AB$1-K7,L7-K7)/7
This works perfectly, my problem is that in some case both L7 and K7 dates maybe be unknown and therefore blank, in this case I need T7 to return 0 and/or ignore the formula until said dates are put in.
T7 is currently returning 6228.
Please help.

 

[Michael M]

Try using

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

 

[Bexcel11]

You my friend, are a legend! That has fixed my issue!! Thank you so much it’s been driving me crazy!!

 

[Bexcel11]

Try using

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

You my friend, are a legend! That has fixed my issue!! Thank you so much it’s been driving me crazy!!

 

[Michael M]

Glad to help....thx for the feedback..