ExcelBanter - How to calculate the Date occurs

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to calculate the Date occurs (https://www.excelbanter.com/excel-worksheet-functions/151766-how-calculate-date-occurs.html)

Blue Fish

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!

papou

How to calculate the Date occurs

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!

Blue Fish

How to calculate the Date occurs

Thanks, I got it from the internet.

All times are GMT +1. The time now is 02:37 AM.