Date formula

[Paul]

What formula would convert this date and time into just
the day month / day / year

8/11/2004 4:53:44 PM

Thanks

 

[Paul]

Sorry meant to say just month / day / year

 

[Bob Phillips]

You could just format it with a date format, or take the integer value

=INT(A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
=INT(A1)
and format as date