Use Excel DATE function to determine day, weekday & weekend.
This video tutorial also provides information to use Excel Color Option (Conditional Formatting) for Specific Text, Cell, Value or Number etc. Excel Color Option is very useful to identify cell from other cells based on cell value.
First view VIDEO TUTORIAL
Important two issues:-
1st- Day Column (as per video) Format Cell --> Number --> Custom --> put DDDD in the TEXT BOX
2nd- Weekday or Weekend Column (as per video)
where return number is given as an integer, rand from 1 (Sunday) to 7 (Saturday), by default)
formula mentioned under