How to calculate the Date occurs

[Blue Fish]

Hello:

Is it possible to calculate the date that has occurs?

If the Format like this:
Sheet 1:
Date
22/07/2007 10:30:02
22/07/2007 10:31:08
22/07/2007 23:11:44
22/07/2007 23:13:20
23/07/2007 00:01:41
23/07/2007 00:04:12
23/07/2007 00:05:04
23/07/2007 00:09:25
23/07/2007 00:10:13

Sheet 2:
Date Occurs
22/07/2007 XXX
23/07/2007 XXX

Thanks!

 

[papou]

Hi Blue Fish
Use a pivot Table and group by Days.

HTH
Cordially
Pascal

 

[Blue Fish]

Thanks, I got it from the internet.