Solved EXCEL If else statement with dates

February 26, 2016 at 03:18:52
Specs: Windows 10
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)


See More: EXCEL If else statement with dates

Report •

February 26, 2016 at 06:43:18
✔ Best Answer
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:


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.

Report •
Related Solutions

Ask Question