The following function might work for you:


=IF(MOD(A1,1)=0.5,INT(A1)+0.5,A1)

The MOD function divides the value in a1 by 1 and returns the remainder, if
the remainder is = .5, it adds .5 to the integer value in A1, otherwise it
returns A1
--
Kevin Backmann


"Suza" wrote:

need to calculate holidays based on no of weeks worked x entitlement =
ROUNDED DOWN TO NEAREST 0.5 DAY

Able to round down but can't understand the 1/2 day