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

Extracting date from Date and Time formatted cell
 

The formula I always use for that is:

=INT(B1)

....and format that cell as DATE.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Aviral Sharma" wrote:

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

Extracting date from Date and Time formatted cell
 

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

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