Thread: how do I set up a formula showing the day based on date?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CoopsCoops CoopsCoops is offline
external usenet poster
  
Posts: 2
Default 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?
Reply With QuoteReply With Quote