Carley
New Member
Good Morning.
I was wondering if there was a way to combine an if and a network days formula.
I have a start date and a completed date, and I want the formula to bring back the amount of network days it has taken to complete the work. (which is easy)
But I want the cell to show a 1 if the completed date is blank, I though that an If option would work but I can't seem to get it to work.
p.s. fantastic new forum and I was able to have a search to see if this had already been asked, but no avail.
I was wondering if there was a way to combine an if and a network days formula.
I have a start date and a completed date, and I want the formula to bring back the amount of network days it has taken to complete the work. (which is easy)
But I want the cell to show a 1 if the completed date is blank, I though that an If option would work but I can't seem to get it to work.
p.s. fantastic new forum and I was able to have a search to see if this had already been asked, but no avail.