=TEXT(the_date,"dddd")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
Hi,

Im trying to automate the process where when i enter someones date of
birth,
i get the actual day that they were born. The function weekday when used
only returns a value between 1 to 7. How can i convert this Number value
to
an actual day? i.e. Monday, Tuesday, Wednesday etc

Thanks to any replies

John