Calculating No. of Working Days Open, if two cells are blank, bu

Hi Alison,

Thank you for your question in our forum. My name is Ron and I am one of the trainers at STL.

What I understand from your question is that you want to execute one action if the dates are both there and no action if one of the dates is missing.

In Excel we can use the IF function to do that. The If function tests a condition and if the condition is true it will do one thing and if it is false it will do something else

The syntax of the IF function is:
=IF(Condition, True Part, False Part)

Related to your challenge, it would have a setup similar to the below. You just need to translate it to the cells and formulas you use.:

=IF(And(Cell with request date="",Cell with End Date=""),"",Networkdays function goes here)


The AND function lets you test multiple conditions and will return true if all the conditions are true.
So in the above function the conditions tested are that the request date cell is empty and the Reply date is empty.
If that is true then you apply a blank cell ("") because both cells have no date. If those conditions are not true, then it will apply the networkdays() function.

If you would like to learn more about Conditional functions and other more advanced functions that can help you tackle more complex calculation challenges then STL has the perfect course for you and currently we do excellent virtual deliveries in Microsoft Teams that are very well received. Just click the link below to see an overview of the topics covered in our Intermediate Excel course and contact one of our guys at STL if you need more information.
https://www.stl-training.co.uk/microsoft/excel-intermediate-courses.php

https://www.stl-training.co.uk/microsoft/excel-advanced-courses.php

Once again thank you for your forum question

Kind regards

Ron Oldeboom
Learning and Development Consultant
STL Training