| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Day / Date Formula
Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am trying to shorten it. NeilM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day / Date Formula
=a1
and format it as: dddd or just format A1 and give that a nice format: mm/dd/yyyy* dddd Neil M wrote: Is there an formula to automatically display the "day of the week" in cell A2 based on a date entered in cell A1? I have one now but it is very long and am trying to shorten it. NeilM -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day / Date Formula
Try this:
A2: =A1 FormatCellsNumber tab Category: Custom Type: ddd Returns Mon, Tue, Wed, etc. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Neil M" wrote: Is there an formula to automatically display the "day of the week" in cell A2 based on a date entered in cell A1? I have one now but it is very long and am trying to shorten it. NeilM |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day / Date Formula
YES!!! I got this from a friend and as you can see, he took the long way
=IF((WEEKDAY(C6)=1),"Sunday",IF((WEEKDAY(C6)=2),"M onday",IF((WEEKDAY(C6)=3),"Tuesday",IF((WEEKDAY(C6 )=4),"Wednesday",IF((WEEKDAY(C6) =5), "Thursday", IF((WEEKDAY(C6)=6), "Friday", IF((WEEKDAY(C6)=7), "Saturday", "Incorrect"))))))) AHHHHHHHHHHHHHHHHHHHHH!!! "Ron Coderre" wrote: Try this: A2: =A1 FormatCellsNumber tab Category: Custom Type: ddd Returns Mon, Tue, Wed, etc. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Neil M" wrote: Is there an formula to automatically display the "day of the week" in cell A2 based on a date entered in cell A1? I have one now but it is very long and am trying to shorten it. NeilM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula with date constraints | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Hybrid Mode
