Thread: How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?
Wesley,

With the date in A1:

=INT(A1)

formatted for date.

HTH,
Bernie
MS Excel MVP


"Wesley Accellent" <Wesley wrote in message
...
I am trying to convert a date & time into a date only so I can get a pivot
table to do a daily summary. Is there a function that can convert? Is there
another way to do a daily summary with a pivot table?


Reply With QuoteReply With Quote