View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WPNX777 WPNX777 is offline
external usenet poster
 
Posts: 1
Default Breaking out Dates from a Date Range

Not sure how to do this or if it can be done. Im am trying to manipulate
data from a Project Management download. In my spreadsheet i have 3 columns;
a task, a Start Date and a End Date (EX: Build House; Start 1/1/08; End
2/1/08).

Is there a way that Excel can look at the start and end dates and then
populate that task for each day it will be done as seperate line items? (EX
Build HOuse on 1/1/08, 2nd row = Build House on 1/2/08, 3rd row = Build House
on 1/3/08,,,etc).

I dont want to do this manually. Please Help. Thanks.