I am trying to create a spreadsheet showing annual leave in a workbook. I
have used countif to calc number of days. but how do i show half days using
formulas.

many thanks

Richard.Gayle