weekday function

[John]

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

 

[JulieD]

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