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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History