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

separating date and time 5
Check if a date comes before/after a range of dates 0
Project Start and End Date is not consistent 1
Subtract 12 hours from date/time 6
How To Have A Cell Be Blank If... 2
Difference in Time hour what formula to use in excel? 4
Return Month & Year of Date Value 1
How to set the function - countif? 6

Top