Difference between dates using IF and TODAY...stuck!

[Related1]

Hi!

I have two columns. If there is a date in the first column, and no date in the second column I would like the second column to be today's date and then continue with my formula to determine the number of days between the two dates.

=networkdays(E14, F14,Holidays!$A$2:$A$15).

If there is no date in the first column, a blank can be returned.

Honestly, I was impressed with myself that I figured out the second part which works when there are dates but I always have a hard time connecting/nesting functions.

Thanks for any help!

 

[Related1]

It worked! Nesting is very logical when I see the answer, yet I'm unable to create it myself.

Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.