Function to write Weekday - Monday, Tuesday etc

S

Shrikant

What is the function to write Weekday only (MOnday, Tuesday etc) from the
given date. For example, when I write date as 26 September 2005, the function
should return the value of Monday.
 
P

papou

Hello
Set a formula refering to the date and simply format cell as dddd
HTH
Cordially
Pascal
 
R

Roger Govier

Hi

You don't need a function.
Format Cells>Number>Custom and set it to ddd

If you did want to do it by function, then
=TEXT(A1,"ddd")

Regards

Roger Govier
 
R

Roger Govier

Apologies, 1 "d" too few.
format as "dddd" or TEXTA(A1,"dddd")

Regards

Roger Govier
 
Top