Remove Time Element of a Date

[jennie]

Hi,

I have a list of cells with a date and time value - I want a formula
that will remove the time element and just leave a date.

Thanks
Jennie

 

[VoG]

With a date in A2

=DATE(YEAR(A2),MONTH(A2),DAY(A2))

 

[Ron Rosenfeld]

Hi,

I have a list of cells with a date and time value - I want a formula
that will remove the time element and just leave a date.

Thanks
Jennie

=INT(cell_ref)


--ron

 

[jennie]

Thanks a lot
Jennie