Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get days of week by entering dates?
How do I set up a function that when I "input a date it gives me the day of
the week" in another column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get days of week by entering dates?
Depending on the format you want displayed.
Full day name: =TEXT(A1,"dddd") Three letter day name: =TEXT(A1,"ddd") HTH, Paul -- "jspaeth" wrote in message ... How do I set up a function that when I "input a date it gives me the day of the week" in another column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get days of week by entering dates?
Hi,
Try this =WEEKDAY(A1) With a custom format of DDD Mike "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get days of week by entering dates?
You don't need the WEEKDAY function, Mike.
=A1 will do the same, if you format as ddd. -- David Biddulph "Mike H" wrote in message ... Hi, Try this =WEEKDAY(A1) With a custom format of DDD Mike "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is fomula for entering dates that are 7 days apart? | Excel Worksheet Functions | |||
Entering week ending dates | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
Applying days of the week to dates | Excel Discussion (Misc queries) | |||
Sorting Dates in Days of the Week | Excel Discussion (Misc queries) |