View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?