Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day Of The Week
Does Excel have the ability to show the day of the week for dates of long past? Example: If I were to type into a cell the date 04/21/1949, can Excel show the day of the week that 04/21/1949 fell on? Thank you for your help!! -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=516374 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day Of The Week
Yes.
Just type the date as an Excel date (like 04/21/1949 and choose one of the date formats in the format menu to get for example Thursday, April 21, 1949 -- Kind regards, Niek Otten "lsmft" wrote in message ... Does Excel have the ability to show the day of the week for dates of long past? Example: If I were to type into a cell the date 04/21/1949, can Excel show the day of the week that 04/21/1949 fell on? Thank you for your help!! -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=516374 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day Of The Week
As long as your date is on or after 01/01/1900 (although Excel gives the wrong day of the week up to 28th Feb 1900 because it treats 1900 as leap year) You can simply format your date as ddd or use a formula in another cell =TEXT(A1,"ddd") where your date is in A1 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=516374 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day Of The Week
Good evening Ismft You can indeed check the days of "long gone" dates, but only so far back. You could enter 21/04/1949 in a cell and change the format to custom "dddd" (without quotes) to give Thursday. Or use a formula if you prefer, eg., =TEXT(A1,"ddd") which would return Thu (use "dddd" to return Thursday). However, this will only go accurately back as far as February 28 1900. Excel was programmed to count 1900 as a leap year when it wasn't. This was done deliberately to ensure compatability with 1-2-3 which made the error originally. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=516374 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day Of The Week
Thank y'all very much, as your suggestion works just fine. I do appreciate your help. Have a nice evening now!! -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=516374 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel |