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

Try this formula instead

=TEXT(F68,"ddd")

If this post helps click Yes
---------------
Jacob Skaria


"Trevor Aiston" wrote:

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

Yep that worked. But tried =WEEKDAY(F68) and that worked too, retaining the
cell as a serial number.

But thanks for your help

Trev

"Jacob Skaria" wrote:

Try this formula instead

=TEXT(F68,"ddd")

If this post helps click Yes
---------------
Jacob Skaria


"Trevor Aiston" wrote:

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

Forgot to mention...DAY() returns the day of a date, represented by a serial
number. The day is given as an integer ranging from 1 to 31....

Try with a date 09/25/2009

WEEKDAY() returns the day of the week

If this post helps click Yes
---------------
Jacob Skaria


"Trevor Aiston" wrote:

Yep that worked. But tried =WEEKDAY(F68) and that worked too, retaining the
cell as a serial number.

But thanks for your help

Trev

"Jacob Skaria" wrote:

Try this formula instead

=TEXT(F68,"ddd")

If this post helps click Yes
---------------
Jacob Skaria


"Trevor Aiston" wrote:

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

You'd better look at help for the DAY function again. It doesn't give day
of the week, it gives 1 to 31, in other words day of the month.

If you want a number for day of the week, look at help for the WEEKDAY
function.
If you want to display the date in ddd format, just use that format on your
original date, or on a cell which merely copies it, e.g. =F68.
If you want it as text, use =TEXT(F68,"ddd")
--
David Biddulph

"Trevor Aiston" wrote in message
...
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