Extracting date from Date and Time formatted cell

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
 
J

JBeaucaire

The formula I always use for that is:

=INT(B1)

....and format that cell as DATE.
 
D

Davesexcel

You can use..
=TEXT(A1,"mm/dd/yyy")

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Month & Year of Date Value 1
Elapse date and time 2
separating date and time 5
How to set the function - countif? 4
COUNT IF A DATE IS HIGHER THAN ANOTHER DATE 3
Subtract 12 hours from date/time 6
Referencing Date problem 4
Date and years calculation 2

Top