Excel Help

Author
Discussion

mc_blue

Original Poster:

2,548 posts

219 months

Sunday 9th December 2007
quotequote all
Good afternoon,

I'd like to be able to ascertain the day of the week from a particular day in Microsoft Excel. For instance from 09/12/07 would it be possible to work out that this is a Sunday. The only caveat is that there is an unequal number of days - i.e. it isn't just a list of one date after another.

With kind regards

mc_blue

Original Poster:

2,548 posts

219 months

Sunday 9th December 2007
quotequote all
Found it here:

=TEXT(WEEKDAY(A2)+1, "ddd&quotwink