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?

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?

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?

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?

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?