Advance MS Excel: Part-2 (Day name from a Date). Commands: WEEKDAY, CHOOSE, TEXT

Here is some example to convert or find out the day name from a date.

Note The second variable indicates the day of the week that the week begins. For example, the variable "1" indicates that the week starts on Sunday, while the variable "2" indicates that the week starts on Monday.

Functions:

=WEEKDAY(A2,1)
=CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
=TEXT(A2,"dddd")
=TEXT(A2,"dd")
=TEXT(A2,"ddd")

Filed Under : #MS Access #MS Excel

Bengal Lyrics

11:30 AM

MS Access MS Excel

0 response