Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
If I have date entered in a cell, can Excel calculate which day it was for me?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
On Fri, 15 Sep 2006 17:42:01 -0700, Swanav
wrote: If I have date entered in a cell, can Excel calculate which day it was for me? Select cell. Then Format/Cells/Number/Custom dddd, mmm d, yyyy --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
Hi Swanav,
Say your date is in A1 then in B1 put =WEEKDAY(A1) This will return a number from 1 to 7, 1 being Sunday and 7 being Saturday. If you want it to show the actual day then format B1 as custom dddd There are a few other options that you will find in the help file. HTH Martin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
Here's another way:
A1 = 9/15/2006 =TEXT(A1,"ddd") = Fri =TEXT(A1,"dddd") = Friday Biff "Swanav" wrote in message ... If I have date entered in a cell, can Excel calculate which day it was for me? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
Thanks a bunch! I just did it and it worked great. I just discovered this
website and it is wonderful as I got my answer in less than 2 hours. Thanks again. "MartinW" wrote: Hi Swanav, Say your date is in A1 then in B1 put =WEEKDAY(A1) This will return a number from 1 to 7, 1 being Sunday and 7 being Saturday. If you want it to show the actual day then format B1 as custom dddd There are a few other options that you will find in the help file. HTH Martin |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
I just discovered this website and it is wonderful
as I got my answer in less than 2 hours. Response time in these groups is measured in minutes, not hours! Although there is the occasional stumper or poorly worded post that no one can understand. Biff "Swanav" wrote in message ... Thanks a bunch! I just did it and it worked great. I just discovered this website and it is wonderful as I got my answer in less than 2 hours. Thanks again. "MartinW" wrote: Hi Swanav, Say your date is in A1 then in B1 put =WEEKDAY(A1) This will return a number from 1 to 7, 1 being Sunday and 7 being Saturday. If you want it to show the actual day then format B1 as custom dddd There are a few other options that you will find in the help file. HTH Martin |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have date, can excel calculate the day for me?
Simply format the cell ddd d/m/yy and the day of the week will be shown
Rob "Swanav" wrote in message ... If I have date entered in a cell, can Excel calculate which day it was for me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
excel array formula | Excel Worksheet Functions | |||
How do I calculate ages in excel using date of birth & another dat | Excel Discussion (Misc queries) | |||
How do I calculate a future date in Excel? | Excel Worksheet Functions | |||
Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) |