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
=IF(OR(WEEKDAY(A5)=7,WEEKDAY(A5)=1),"WEEKEND","WEEKDAY")

Stay Connected With Free Updates

Subscribe via Email
You can leave a response, or trackback from your own site.

Pijush Roy, Founder & Author of "Share Your Knowledge", is a young freelance blogger, a reader, a painter, .....read more


Followers

IMPORTANT LINK/URLs

m