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!
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!