Duplicate rows based on date difference
 

I have a sheet with dates in both column E and F. If the date in
column F is greater than the date in column E, the specific row needs
to be copied a number of times, depending on the number of days
between the date in colums F and E.

Example:

row columns E column F
1 16-01-72 16-01-72
2 18-01-79 20-01-83

row 2 needs to be copied automatically 4 times here ( 1 for '80, 1 for
'81, 1 for '82 and 1 for '83)

Thanks for your help !!

Mark

Duplicate rows based on date difference
 

See other post.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ixtreme" wrote in message
oups.com...
I have a sheet with dates in both column E and F. If the date in
column F is greater than the date in column E, the specific row needs
to be copied a number of times, depending on the number of days
between the date in colums F and E.

Example:

row columns E column F
1 16-01-72 16-01-72
2 18-01-79 20-01-83

row 2 needs to be copied automatically 4 times here ( 1 for '80, 1 for
'81, 1 for '82 and 1 for '83)

Thanks for your help !!

Mark