Thank you for the respone. Tried it and it does not do exactly what i need. I have 2 cells that contain a start date and then current date. I am needing the spread sheet to auto generate a new line in the spreadsheet for each day between the start and current date. This sounds simple but it is turning out to be very hard to do. I appreciate the help.