Hi,

I am trying to calculate pay based on hours worked and the date/day of the week I worked.
I have tried to use IF and WEEKDAY functions but haven't been able to work out the right formula, and am not sure if it's the correct approach.

I want to be able enter the hours worked next to the day and date, and have excel calculate the amount earned for that day under the right rate column, to look a bit like this Screen Shot 2017-06-28 at 10.54.36 PM.png

This will eliminate some error, and make it one step easier than the system I have.

Any help is much appreciated.