Have a look in the help index for
days360 or yearfrac

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Daoud Fakhry" wrote in message
...
Dear all,
I want to calculate our employees benefit from a specific date up to now
which covers 7 months. How should determine a specific period so it
returns
me a specific value considering different hire dates of employees.
Ex:
I need a fomula to calculate the number to months and considering the
following:
if the hire date between 1 and 15 Jan it should return me 7 months and if
an
employee hire date is between 16 and 31 Jan then it should return me 6.5
months and also if the hire date is between 1 and 15 Feb then it should
retrun 6 months and if the hire date is between 16-28 Feb it should be 5.5
months.
Thanks,