Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transforming date ranges into discrete dates
I would like to transform the following type of file format:
Person Event Start Stop 1 1 1/1/03 1/2/03 1 2 1/7/03 1/9/03 1 3 2/1/03 2/2/03 2 1 3/1/03 3/3/03 etc... Into a format in which each date in each range, inclusive of the boundaries, is represented. Person Event Date 1 1 1/1/03 1 1 1/2/03 1 2 1/7/03 1 2 1/8/03 1 2 1/9/03 1 3 2/1/03 1 3 2/2/03 2 1 3/1/03 2 1 3/2/03 2 1 3/3/03 etc... This is something I would want to do each time I opened the worksheet. The source data come from an Access database; hence, the # rows per person, and the number of persons per worksheet, are not fixed (i.e., would not necessarily be the same each time I do this transformation). I've being trying to write a custom function to return an array, but so far have been unsuccessful (I've not written custom functions before). Perhaps this is not the best approach... Any help would be greatly appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
switch off transforming number into date | Excel Discussion (Misc queries) | |||
switch off transforming number into date | Excel Discussion (Misc queries) | |||
how can i networkdays date ranges where dates overlap | Excel Worksheet Functions | |||
How do I select the nearest date from a ranges of dates? | Excel Discussion (Misc queries) | |||
How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions |