Need help writing a complicated formula. Want formula to stay zero until the
criterias are met as explained below. When criterias are met, want formula
to automatically add a 1, 2 or 3 in the cell based on the hire date after 6
months of service.

After 6 months of service, you get one sick day; then three days maximum a
year (January - December). If first year anniversary falls on January -
June you get 3 sick. If it falls on July - Sept you get 2 sick for remainder
of year. If it falls on Oct - Dec you get 1 sick day for remainder of the
year. Sick days do not carry forward to the next year.

Examples

Hire Date: July 1, 2006
Six months of service date: Jan. 1, 2007
Sick leave accumlated after six months: 1
First Year Anniversary Date: July 1, 2007
Sick leave accumlated: 2 more for remainder of 2007

Hire Date: Jan. 1, 2006
Six months of service date: July 1, 2006
Sick leave accumlated after six months: 1
First Year Anniversary Date: Jan. 1, 2007
Sick leave accumlated: 3 for 2007

Hire Date: Oct. 1, 2006
Six months of service date: April 1, 2006
Sick leave accumlated after six months: 1
First Year Anniversary Date: Oct. 1, 2007
Sick leave accumlated: 1 for remainer of 2007