Hi all,
We are paying the health benefit to our employee on a quarterly basis
(calender base). We considered that if an employee joined the company between
1 Jan and 31 Mar we will count it 1 quarter and the same till end of the
year. Our employee is eligible for $1,000/year or $250/quarter. I want the
following to be calculated in a formula:

if the employee hire date is between 1 Jan to 31 Mar it should give me 1st
Quarter
if the employee hire date is between 1 Apr to 30 Jun it should give me 2nd
Quarter
if the employee hire date is between 1 July to 31 Aug it should give me 3rd
Quarter
if the employee hire date is between 1 Sep to 31 Dec it should give me 4th
Quarter

or it will be better to calculate the # of quarters between the hire date
and the benefit payment base date.

Or I am currently in December 2006 and want to calculate our employees
health benefit to calculate the # of quarters between the employee hire date
and 31 dec 06?

Thanks for all of your cooperations,
Best,
Daoud Fakhry