i almost have it figured out

[snowsurfer]

I am trying to create a time sheet. I almost have it figured out. The overtime law for CAlif is
DAILY OVERTIME COMPENSATION

The law establishes new overtime compensation rules for employers. These rules apply to hourly employees who are non-union, not exempt and do not work under an alternative workweek schedule. Employers are required to pay their employees overtime as follows:

Pay time and a-half pay after eight hours of daily work and double pay after 12 hours of daily work.
Pay time and a-half pay after 40 hours of work in one workweek and for the first eight hours worked on the seventh day of work.
Pay double time for hours worked in the excess of eight hours on any seventh day of a workweek.

I have it all worked out except how to count if this is the seventh day worked. I can email anyone the file if you can help so that you can see what I have. Thanks

[George J]

At home right now, so don't have access to excel, but using the weekday function is the answer. if weekday = 1, this is Sunday.

Hope you can work it from here.