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 FormatCellsNumberCustom 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" wrote
in message ...

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"
escribió en el mensaje
...

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