|I have a spreadsheet for logging our employees holiday record. |
Currently I use a formula to calculate the number of working days taken -
(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?