Convert the date to day of the week.
On Sat, 22 Mar 2008 17:30:00 -0700, Nils Titley
wrote:
I need to convert the date 22/03/08 which is dd/mm/yy to what day it is which
is Saturday. Is there a function that does that? Or how can I do what I
want?
Thanks
You can format the cell (Format/Cells/Number/Custom Type: "dddd")
or you can use a formula:
=TEXT(cell_ref,"dddd")
--ron
|