Remove Time Element of a Date
 

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


--
jennie
------------------------------------------------------------------------
jennie's Profile: http://www.excelforum.com/member.php...fo&userid=6706
View this thread: http://www.excelforum.com/showthread...hreadid=385529

With a date in A2

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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1

On Fri, 8 Jul 2005 03:42:22 -0500, jennie
wrote:


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

Thanks a lot
Jennie


--
jennie
------------------------------------------------------------------------
jennie's Profile: http://www.excelforum.com/member.php...fo&userid=6706
View this thread: http://www.excelforum.com/showthread...hreadid=385529