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!