Formula to show blank if subtracting two dates when date columns are empty (new rows)

[lfcreds11]

Hi,
I am using this formula =IF(L9="",TODAY()-I9,L9-I9) to calculate the number of days a project has been open. Column I has the open date, Column L has the closed date. The way I wrote the formula is that is the project is not closed and there is no date listed in column L then use today's date to calculate the days open. That is working fine. The issue I am having is for new rows which do not have any dates in column I and L the number 44944 populates. How can I get that to show as blank or 0 as part of the formula?

Thanks!

 

[Fluff]

How about

=if(I9="","",IF(L9="",TODAY()-I9,L9-I9))

 

[xlhelp15]

Try this !

=IF(I9="","",IF(L9="",TODAY()-I9,L9-I9))

 

[lfcreds11]

How about

=if(I9="","",IF(L9="",TODAY()-I9,L9-I9))

This worked thank you so much!!

 

[lfcreds11]

Try this !

=IF(I9="","",IF(L9="",TODAY()-I9,L9-I9))

This worked! Thank you so much as well for responding!!

 

[Fluff]

Glad we could help & thanks for the feedback.