WEEKDAY FUNCTION [Conditional Formatting] : TEXT Function

 Convert Date to Day using Excel fuction :

Use Text(value, format_text) :  Here Value means cell reference and format means in which format you want to see like 

• "dddd" = only Day i.e Sunday, Monday, Tuesday etc.
• "mmm-dddd" = Month and Day i.e Jan-Sunday, Jan-Monday etc
• "dddd-mmm-yy" = Day-Month-Year

Now we will discuss about weekday function. This function will help you to mark the specific date as per day. First remember the number series which start from 1 to 7. Where 1 means sunday

Syntax
WEEKDAY(serial_number,[return_type])
When we use weekday function in conditional formatting and if you want to select specific day then write as follow
=weekday(reference cell)=1 if sunday
                                           =2 if Monday
                                           =3 if Tuesday etc. 

If you want to highlight more than one date by day then the following formula  =WEEKDAY($D4,1)>5 [ Here 1 means the serial number of days starts from Sunday(1), Monday(2), Tuesday(3), Wednesday(4), Thursday(5), Friday(6), Saturday(7) and >5 meams you want to highlight Friday(6) & Saturday(7) ]

and if you want to highlight saturday and sunday then use =WEEKDAY($D4,2)>5 [ Here 2 means week will start from Monday i.e 1, Tuesday(2), Wednesday(3), Thursday(4), Friday(5), Saturday(6), Sunday(7) ]

For Support & Feedback :

If you have queries, you may share comment and give feddback which will inspire me. Thanks for visit this blogs.