ERP Technical | Advance Excel, VBA, Power BI Developer

Excel Date, Weekday and Weekend Function


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")
Labels:
Reactions:

Post a Comment

good work bro

[blogger][disqus][facebook]

MKRdezign

{facebook#https://www.facebook.com/proy20152016}

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget