Thread: If I have date, can excel calculate the day for me?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default If I have date, can excel calculate the day for me?
Here's another way:

A1 = 9/15/2006

=TEXT(A1,"ddd") = Fri
=TEXT(A1,"dddd") = Friday

Biff

"Swanav" wrote in message
...
If I have date entered in a cell, can Excel calculate which day it was for
me?


Reply With QuoteReply With Quote