Thread
:
Remove Time Element of a Date
View Single Post
#
3
Ron Rosenfeld
Posts: n/a
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
Reply With Quote