Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a data file that looks like this.
26-Jan-68 1.02088 1.02088 1.02088 1.02088 2-Feb-68 1.01608 1.01608 1.01608 1.01608 9-Feb-68 1.01577 1.01577 1.01577 1.01577 16-Feb-68 1.01425 1.01425 1.01425 1.01425 .......... The current date fall on FRI. I want to add new rows with dates for the following MoTuWeTh and copy the data from the last record into new rows. In this example I will need to add 4 rows between 26-Jan-68 and 2-Feb-68, append dates that correspond to MoTuWeTh following 26- Jan-68, and copy the data for 26-Jan-68 into these new rows. I need to do this for all rows (which ends on current week--lots of rows to do manually). Any help will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
How to make weekly totals change as the days in the week change ye | Excel Programming | |||
Converting daily data into weekly | Excel Discussion (Misc queries) | |||
Converting Daily Info to Weekly | Excel Discussion (Misc queries) | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions |