It hurts my feelings that it is that easy, but it works great.

Just what I needed.

Thanks,
Wesley

"Bernie Deitrick" wrote:

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?