View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default How to get days of week by entering dates?

Assuming the date is in A1, create the following formula in the cell you want
the day of the week in:

=A1

Then select the formula cell and click FORMAT, CELLS from the menu and click
the NUMBER tab.

In the CATEGORY column select CUSTOM and then in the text box to the right
of the CATEGORY column enter the following format mask:

dddd

Click OK to exit.
--
Kevin Backmann


"jspaeth" wrote:

How do I set up a function that when I "input a date it gives me the day of
the week" in another column?