Date formula

P

Paul

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

8/11/2004 4:53:44 PM

Thanks
 
B

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)
 
Top