Followed the help and used Day function to calculate the day of the week then
formatted as custom to ddd to show short day name.

But sometimes it returns wrong day. e.g.
09/05/2009 (F68). Formulae G68 is =DAY(F68), returns Mon. Buts its actually
Sat???

Any ideas
Thanks
Trevor