Help finding dates July thru June
 

Hello,

I'm trying to create a cost worksheet that will calculate cost of
giving a raise but the problem comes in with dates. Our fiscal year
runs July thru June, so this has added to my confusion. I will try to
explain better:

Joe Smith, Hired in Aug. He gets a 5% raise on his anniversary date
every year, but also gets a 3% cost of living raise every July. So he
gets 3% for one month and then a total of 8% (5% + 3%) for the
remaining 11 months. One on one this is not a problem but with over 100
employees all with different hire months and different pay levels, it
becomes tough.

I guess my confusion comes from subtracting fiscal year instead of a
calendar year. Any help would be greatly appreciated!

Thanks...mitch