Add new co un readings starting in column I to display calculators for Current Annual Earnings New Monthly Hourly Rates Projected Annual Earnings in 2014 and the Grass Pay Increase in 2014 Earnings Pay Increases starting on Aor I and continuing to the end of December 31 2014 must be included in the Projected Annual Earnings Create a manual formula that uses the initial pay rate and time worked for January March and the new pay rate and time worked for Aor ! - December Add appropriate start and end dates in the upper section of your database worksheet and item use the YEARFRAC in your Projected Annual Earnings formulas . This w make your formula text s to pay rate increases in the future Notes : New monthly rates should be rounded to O new hourly rates should be rounded to 2 ( USE IF statement here New hourly salary increases effective on April 1 will apply to 314 of the time worked for the year Format all other wage and earnings wells using the comma format , all earnings columns should be rounded to the nearest dollar