I am creating a spreadsheet to keep track of time balances. We have three
types of balances to keep track of; Vacation, Sick, and Personal. A vacation
day is accrued each month on the anniversary date of the start date. A sick
day is accrued every 2nd, 6th, and 10th month after the start date and two
sick days and a personal day are accrued every 4th, 8th, and 12th month after
the start date.

For example, if the person started on Feb. 14th, then they would accrue a
vacation day each month on the 14th. They would accrue one sick day on April
14th, August 14th, and Dec. 14th. They would accrue two sick days and one
personal day on Jun 14th, Oct 14th, and (obviously) Feb 14th.

In my spreadsheet, I am calculating each day type (vacation/sick/personal)
separately. I have Column A filled with each day of the year.

My 1st question is how do I write a formula in Column B to say, "If the date
in Column A falls on the 14th then one vacation day is accrued?"

My 2nd question is how do a write a formula in Column C to say, "If the date
in this row in Column A falls on the 14th and the month falls on the 2nd,
6th, or 10th month after the start date, then one sick day is accrued but if
the date in this row in Column A falls on the 14th and the month falls on the
start date or the 4th, or 8th month after, then two sick days are accrued?"

I presume I can figure out the fomula for the personal day accrual based on
the sick day formula.