| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I set up a formula showing the day based on date?
I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like
another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.) ....in otherwords, calculated by what date appears in the former cell... how do I do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I set up a formula showing the day based on date?
.....set B1 =A1
"CoopsCoops" wrote: I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.) ...in otherwords, calculated by what date appears in the former cell... how do I do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I set up a formula showing the day based on date?
Custom Format cell as "ddd" (no quotes)
"CoopsCoops" wrote: I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.) ...in otherwords, calculated by what date appears in the former cell... how do I do that? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I set up a formula showing the day based on date?
In B1: =A1
format cell as: ddd "CoopsCoops" wrote: I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.) ...in otherwords, calculated by what date appears in the former cell... how do I do that? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I set up a formula showing the day based on date?
=TEXT(A1,"ddd")
-- Regards, Peo Sjoblom "CoopsCoops" wrote in message ... I have a date in mm/dd/yyyy listed in one cell (Cell "A1"), and I'd like another cell ("B1") to list the actual day A1 represents (MON, TUE, etc.) ...in otherwords, calculated by what date appears in the former cell... how do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula based on date | Excel Worksheet Functions | |||
| Need to create formula based on date | New Users to Excel | |||
| Need to create formula based on date | New Users to Excel | |||
| Current date formula based on month | Excel Discussion (Misc queries) | |||
| Convert formula to value based upon date | Excel Discussion (Misc queries) | |||
Linear Mode
