EN
Google Spreadsheet - how to get name of day for specific date?
13 points
To get name of day in Google Spreadsheet following solution can be used.
Use following formula in cell you want to keep day name:
xxxxxxxxxx
1
=CHOOSE(WEEKDAY(B2),"Sun", "Mon","Tue", "Wed", "Thu", "Fri","Sat")
Where: B2 cell keeps the date you want to know day name.

If we want to use full names of day of the week, here is the formula:
xxxxxxxxxx
1
=CHOOSE(WEEKDAY(B2), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")