How to count number of days

[Tryingtoresolve]

I need it to displaybl the quantity number of days in M2 if L2 is an empty cell M2 counts the days between J2 and Today but once a date is entered into L2 it M2 counts the number of days instead between J2 and L2 the below formula works fine if L2 is populated this is the formula I am using

=IF(L2="",TODAY()-J2,L2-J2)

 

[Fluff]

That formula & the results look fine. In what way do you think it's wrong?

 

[Tryingtoresolve]

That formula & the results look fine. In what way do you think it's wrong?

Sorry I have just retested it and now seems to work fine thank you for checking anyway I'm not sure what happened before

 

[Fluff]

You're welcome & thanks for the feedback.