Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
expanding a start date and end date to show all the dates in a list
Can anyone help tell me how to do this. I think it should be possible
in excel but if not can you tell me what it could be done in. Imagine that you had a list of people and the dates that they borrowed say a CD set up in a spreadsheet eg CD1 Peter 25/05/2005 30/05/2005 CD2 peter 08/08/2005 15/08/2005 CD2 paul 02/03/2005 04/03/2005 What I want to be able to do is convert this list into a pivot table/Cross tab query that will show the persons name down the CD down the left and will have every day of the year along the top and as a value state who had it. Has anyone got any ideas of how to tackle this. It must be possible Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAYS360 where Start Date is Static and End Date is Latter of Two Dates | Excel Discussion (Misc queries) | |||
elapsed dates between start and end date and time | Excel Discussion (Misc queries) | |||
List of dates for month from start date | Excel Discussion (Misc queries) | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
How to make drop-down list of dates start with current date? | Excel Discussion (Misc queries) |