Smart-ass :-)

I think I might just use that!

Regards

Bob


"Jason Morin" wrote in message
...
Same concept as what Bob's given you, just shorter:

=SUMPRODUCT(ISNUMBER(FIND({"l","L"},D1:D20))*{0.5, 1})

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.