FAQ: How to display the day of the week?

Here you will find a lot of Frequently Asked Questions.

Warning: commas (,) are used here but depending on your excel version it will be semi-columns (;)

1) The formula =WEEKDAY(A1) will give you the day of the week for the cell A1.

2) But it does not show which day in terms of Monday, Tuesday, etc...

So type instead

=CHOOSE(WEEKDAY(A1), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")

And this should make the trick.


2.2) Another way it to change the format of the cell or cells (as you can select multiple cells too).

So you can right click on the cells or go to the menu format cells and then go to the number tab and select Custom from the Category list.

You can type a custom number format string into the box labeled Type.

Important is the you can type d for days in 4 ways, d, dd, ddd, dddd.

Try them. typing dddd mmmm d, yyyy will display the date and the day of the week, like this: Tuesday July 10, 2012.

Hope this helped. Try ou templates and exemples.

Here you get some picture and images of how to do it.