• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining a Networkdays and If formula?

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.
 
Hi ,

Why not ? What happens if you use an IF formula as follows :

=IF(ISBLANK(Completed_Date),1,NETWORKDAYS(Start_Date,Completed_Date,Holidays_List))

Narayan
 
Thank you so much, I kept getting the bracket in the wrong place and #value! kept appearing!!
 
Back
Top