Remove time from date time

  • Thread starter Thread starter Prem Chandiramani
  • Start date Start date
P

Prem Chandiramani

Hi,

Does anyone know how i can remove the time value from a cell whose
data is date time.

I need to do this to perform some calculation and not just for
formatting so the Selection.NumberFormat = "dd-mmm-yy" will no work.

Thanks in advance
Prem
 
Prem,

Dates & Times are stored as follows-

Dates are whole integers stored as "Days-Since-1900", Times are stored as
fractions of a day e.g. 0.5 is 12 midday.

To get just the Date portion use the formula-

=INT(A2)

which strips off the Time portion.

regards,

JohnI
 
Back
Top