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,

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,

Or use this

=IF(DAY(Date)-DAY($B11)0,1,0.5)+MONTH(Date)-MONTH(B11)+(YEAR(Date)-YEAR(B11))*12

Peter

"Daoud Fakhry" wrote:

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,

Sorry date was a range name to the today function
Peter

"Daoud Fakhry" wrote:

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,