Apologies, 1 "d" too few.
format as "dddd" or TEXTA(A1,"dddd")
Regards
Roger Govier
Roger Govier wrote:
Hi
You don't need a function.
Format CellsNumberCustom and set it to ddd
If you did want to do it by function, then
=TEXT(A1,"ddd")
Regards
Roger Govier
Shrikant wrote:
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.
|