Thread: Formula for day of the week to relate to corresponding date cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Formula for day of the week to relate to corresponding date cell
If your date is in A1, then in B1 enter:

=A1

format B1 as Custom dddd
--
Gary''s Student - gsnu200765


"Cadders" wrote:

I am not a programmer but can do some basic instructions in excel cells but I
am not able to solve this one. In Excel 2002xp I have a date in one cell and
would like this to display the actual weekday in another cell. Is there a
formula for achieving this?
--
Cadders
Reply With QuoteReply With Quote