Month formula not calculating correct

Hi All:

I had a spread sheet to calculate employee sick time as it accumulates month by month. Our fiscal year goes from April 1, 13 to March 30, 14. The formula was working well ( =10.5*MONTH(TODAY())-31.5 ) until Jan when the year changes. The formula has now changed from calculating from April to Jan as the MONTH goes from Jan to Dec.

Is there a way to create a formula that will do the following.

1. Each employee is entitled to 10.5 hours of sick time on the 1st of each month.
2. This time is calculated from Apr 1, of the year to Mar 30 of the next year.

Apr 10.5
May 21
Jun 31.5
Jul 42
Aug 52.5
Sep 63
Oct 73.5
Nov 84
Dec 94.5
Jan 105
Feb 115.5
Mar 126

Any help with the formula would be greatly appreciated as it is causing havoc at this time and I cannot figure out the resolve for this issue.

Awesome it appears to be working. Thanks again for the quick response.

how do I close this thread since it has been resolved??