Using days of the week to calculate payment to part-time workers

I would like to convert a day of the week in cell (e.g. Saturday in cell G2), into it's numerical value in another cell (e.g. "7" in cell K2) so that I can use a formula:

=SUM(INT((WEEKDAY(T2-DAY(T2)+1-R2)+(DAY(DATE(YEAR(T2),MONTH(T2)+1,0))-1))/7))

to calculate how many of those weekdays (Saturdays in my example) there are in a specific calendar month. Is there a formula for this?

Payroll.xlsx

Thanks in advance.

Hello
Try the following in cell K2 down:

=MATCH(TRIM(G2),{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)

It's not elegant but I can't come up with anything else at the moment unless you use a Lookup Table. I've used the Trim function because some of your days in column G have spaces at the end. If not removed the Match function won't find a match.

Hope this helps.

Thanks DBY! That does do the trick.

Sorry about the unnecessary spaces in the data entry for cell K2 - I should have double-checked that for consistency. After cleaning that up, I removed the TRIM function and voila, it works perfectly.

Cheers.