Counting Dates

[Guest]

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,

 

[Don Guillett]

Have a look in the help index for
days360 or yearfrac

 

[Guest]

Or use this

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

Peter

 

[Guest]

Sorry date was a range name to the today function
Peter