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

HTH
Cordially
Pascal

"Blue Fish" a écrit dans le message de news:
...
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!