Excel Help

[mc_blue]

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]

Found it here:

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

[Legmaster]

You could use the following date format

ddd dd/mm/yy

[AtomicRex]

or to get Sunday dddd dd-mmm-yyyy

[mcflurry]

Use the Julian date function, and then use the MOD function with a factor of 7

[LordGrover]

mc_blue said:

Found it here:

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

So the

")

bug's not fixed yet then?