Remove time from date time

[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

 

[JohnI in Brisbane]

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