# How to get specific data if the date is on weekend?

I'm trying to create a timesheet where I can calculate the normal hours, overtime and weekend hours.

So far I managed to get the list of dates calculate hours worked and which is overtime, but what I can't figure out is how to calculate the worked hours on weekends, because I have 3 rates to pay (for normal hours, overtime and work on weekends).

I could to that if I put like a check box next to each date and manually select the weekends, but I wonder if I could do it automatically.

``````=IF(OR(WEEKDAY(A11)=7,WEEKDAY(A11)=1),D11,0)
• First, thank you very much for the answer it helped me a lot, but i need just a small help with this answer, the formula is great but how can i make it that if A11 is empty then the cell with this formula to be blank as well. On Hours and Overtime i used the IFS function like `=IFS(A11="", "", G11>0,0, G11=0, MAX(D11-8,0))` but not sure how to use this on your formula
• I am glad to help. `=IF(A11="", "", IF(OR(WEEKDAY(A11)=7,WEEKDAY(A11)=1),D11,0))` Commented Aug 28, 2021 at 8:07