Formulas, employee eval date &....

I need help with two formulas,
1st one, A1 = 07/01/08. If A1 falls between the 1st and the 15th of the month, the desired result would be A2="August". Would need the next month for any date between 01 and 15.

If A1 falls between the 16th and the 31st, the desired result would be 60 days out. i.e. if A1 = 07/16/08, A2 = 09/14/08, if A1 = 07/31/08, A2 = 09/29/08.

2nd formula, I have a Employee Schedule template that calculates hours. My only problem is putting text such as OFF, VACATION, etc.. in the cells where it is formatted to have times such as 10:00 AM to 2:00 PM. The formula that calculates the overall hours will not work if text is in these cells. How do I get it to ignore the text? I know it's possible, I've seen it in other ssheets, but have had no success myself.

Any help with either formula would be greatly appreciated!