| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate the Date occurs
Thanks, I got it from the internet.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| How do I calculate times each word occurs in a column of cells? | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
Linear Mode
