Thread: Time & Date Formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Time & Date Formulas
Gary''s Student wrote...
In B3 anter
=A3 and format to dddd
....

If the OP needs to use B3 in other formulas, maybe better that the B3
formula were

=TEXT(A3,"dddd")

with no special number formatting needed.
Reply With QuoteReply With Quote