Thread: Extracting date from Date and Time formatted cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aviral Sharma Aviral Sharma is offline
external usenet poster
  
Posts: 11
Default Extracting date from Date and Time formatted cell
Hi

I have a date and time in cell A1 e.g. 3/14/2008 03:45 PM and in cell B1 I
only want date not the time i.e. 3/14/2008.

can someone help me with some formula for this.


Regards
Aviral Sharma
Reply With QuoteReply With Quote