Solved How to get a NETWORKDAYS calculation within a IF Statement

March 18, 2015 at 05:40:34
Specs: Windows 8.1
I have a spreadsheet for logging our employees holiday record.

Currently I use a formula to calculate the number of working days taken -

=NETWORKDAYS(B12,C12,Summary!$B$46:$B$53)

(where B12 is start date, C12 is end date, and the Summary sheet holds the list of bank holidays in the referred to cells)

This works great - until someone only takes half a day off. I'd like to leave the C12 date blank and then return the value 0.5 if its blank.

Any ideas how to do it please?


See More: How to get a NETWORKDAYS calculation within a IF Statement

Report •


#1
March 18, 2015 at 07:18:15
✔ Best Answer
You could try something like this and see if it works for you:

=IF(C12="",.5,NETWORKDAYS(B12,C12,Summary!$B$46:$B$53))

MIKE

http://www.skeptic.com/


Report •

#2
March 18, 2015 at 08:37:01
This worked perfectly Mike - thank you for your help and your quick response - it all depends on where you put those brackets!

Report •

Related Solutions


Ask Question