Let's say A1 is the 'from date' and B1 is the 'to date'. I need a formula in C1 that will provide the number of the work days between A1 and B1 then subtract 1 day. Where there is no value in B1, I would like C1 to default to 0. Any ideas? Thanks in advance!