Extract Date from Date & Time Cell

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Can someone help with this please

I need to extract the date portion from a cell that contains a date &
time. I need this "date only" cell to be within a range that I output
to access. However changing the format of the cell only seems to change
what is viewed and the time is still outputted to access which I dont
want

Isnt there a format statement or something I can do within this cell to
prevent the time portion to be outputted as well?

Thanks in Advance
 
Scott

if the cell is formatted as general, you will see a number of the format
nnnnn.nnnnn. The part before the decimal point, period, whatever, is the
date and the number after the period is the time.

So, assuming the date and time is in cell A1, the formula =INT(A1) will give
you the date. You could copy this and use Paste Special | Values to
overwrite the original date and time.

Regards

Trevor
 
Thanks Trevor, I may not be following tho. This just gives me a whole number
fir that cell within my range. So If I output that to access it will just be a
number ie 38031. How can I have the cell show say 02/14/2004 ????
 
Try formatting those "date-number" cells as dates.

As an experiment, try the opposite. Type: 02/14/2004 in an empty cell. Format
it as General.

That's how excel stores the date values--just numbers.

Chip Pearson has some notes that you may want to peruse--it explains
dates/times.
http://www.cpearson.com/excel/datetime.htm
 
Back
Top