Extracting date from Date and Time formatted cell

  • Thread starter Thread starter Aviral Sharma
  • Start date Start date
A

Aviral Sharma

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
 
You can use..
=TEXT(A1,"mm/dd/yyy")

or
=A1 and then format the cell to the date format
 
Back
Top