Function to write Weekday - Monday, Tuesday etc

[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.

[papou]

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

"Shrikant" <Shrikant@discussions.microsoft.com> a écrit dans le message de
news: C9A5BA2A-7626-4C45-B3E7-67B8AC88C6A6@microsoft.com...
> 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.

[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


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.

[Roger Govier]

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 Cells>Number>Custom 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.