Excel 2010 > Bi-Weekly Paycheck Tracker

Hi,

I'm working on, what should be, a very simple spreadsheet. There are 13 worksheets in total.

The idea behind this spreadsheet is to input the hours worked each day (entered in the calendar : January-December on their respective dates), and then on worksheet 1 titled "Payday" pull those hours, multiply it by the "HOURLY PAY RATE" (Cell: H3) & add the "DAILY PAY RATE" (Cell : H8) to that value.

I've included two images to help you understand what I'm looking to accomplish.

Worksheet1.jpgMonthly.jpg

Hi
Please upload a sample worksheet (Not image) if you want an answer.

Regards

hI
Check the attached

I have done some midterm calculation

You have to change the formula slightky for each biweek

Regards