Formula to Indicate name of day (Sunday, Monday etc..) based on a Date

Can someone help me figure out the formula for showing the name of day based on a date.

Just Format>Cells>Number>Custom tab. In The Type box, enter ddd or dddd
This leaves the date a date. Alternative in another cell:

=TEXT(A1,"ddd")

This makes the cell text.

"dannboy213" <dannboy213.22ijmm_1138734604.0768@excelforum-nospam.com> wrote
in message news:dannboy213.22ijmm_1138734604.0768@excelforum-nospam.com...
>
> Can someone help me figure out the formula for showing the name of day
> based on a date.
>
>
> --
> dannboy213
> ------------------------------------------------------------------------
> dannboy213's Profile:
> http://www.excelforum.com/member.php...o&userid=31017
> View this thread: http://www.excelforum.com/showthread...hreadid=506889
>

Just give a special format to the cell contaning the date, something like
dddd
Right click --> Format cells

"dannboy213" <dannboy213.22ijmm_1138734604.0768@excelforum-nospam.com>
escribió en el mensaje
news:dannboy213.22ijmm_1138734604.0768@excelforum-nospam.com...
>
> Can someone help me figure out the formula for showing the name of day
> based on a date.
>
>
> --
> dannboy213
> ------------------------------------------------------------------------
> dannboy213's Profile:
> http://www.excelforum.com/member.php...o&userid=31017
> View this thread: http://www.excelforum.com/showthread...hreadid=506889
>

You could just format the cell containing the date using custom set to
dddd. If you want to see the day and the date, you could custom format
the cell as dddd, dd/mm/yyyy (UK format).

Alternatively, if you want to show the day in a separate cell and your
date is in A1, enter this formula in cell B1:

=WEEKDAY(A1)

and format this cell as custom dddd.

Hope this helps.

Pete

I all you want is the day of the week, this will do the trick...

=CHOOSE(MOD(DateValue,7),"Sun","Mon","Tue","Wed","Thurs","Fri","Sat")

So, if your date is in A1 the formula would be entered as:

=CHOOSE(MOD(A1,7),"Sun","Mon","Tue","Wed","Thurs","Fri","Sat")
--
Kevin Backmann


"Pete" wrote:

> You could just format the cell containing the date using custom set to
> dddd. If you want to see the day and the date, you could custom format
> the cell as dddd, dd/mm/yyyy (UK format).
>
> Alternatively, if you want to show the day in a separate cell and your
> date is in A1, enter this formula in cell B1:
>
> =WEEKDAY(A1)
>
> and format this cell as custom dddd.
>
> Hope this helps.
>
> Pete
>
>