View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blue Fish Blue Fish is offline
external usenet poster
 
Posts: 3
Default How to calculate the Date occurs

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!