View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Time & Date Formulas

Thanks Harlan! I used this and it's returning "TRUE" Do you know what happened?
Thanks, Karen

"Harlan Grove" wrote:

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.