weekday function

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top