I am trying to create a formula that will calculate net workdays between two dates, and if the end date is blank, it calculates the net work days between the start date and today's date
=NETWORKDAYS(Q317,W317)
is what I have for start,end date.
how would I make a function for "if end date blank, then network days (Q137,today)
Thanks for help!!
Bookmarks