I want to put hourly rates of $6 alongside weekdays and $7 for weekends. I did this it doesn't work:

=IF(A2=weekday, 6, 7)

Help?

The WEEKDAY function must refer to a cell that contains a date. Assuming your system is set up such that Sunday is weekday 1 and Saturday is weekday 7, this should work:

=IF(AND(WEEKDAY(A2)<>1,WEEKDAY(A2)<>7),6,7)

For any WEEKDAY not equal to 1 or 7, the function will return 6.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History