weekday function

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?

Thanks to any replies

John

Hi John

you can do this by formatting the cell without using any functions at all
enter birthday in A1
click on A1 and choose format / cells / number tab - custom, in the white
line type
dddd
to get just the day
or something like
dddd dd mmmm yyyy
to get day at date
click OK and make the cell wider.

If you want to change this into a text entry in another cell put the
birthday in A1
then in B1 type
=TEXT(A1,"dddd")

Cheers
JulieD

"John" <jason_dougan@hotmail.com> wrote in message
news:c9uDd.386$6L6.371@newsfe3-win.ntli.net...
> 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?
>
> Thanks to any replies
>
> John
>

I have Been Looking for information on how too do this and you
just made my day even if it was almost 2 months ago!!
I just can't believe it was that simple.....But you just put my mind too rest so thankyou