i have got two sheets in sheet 1
A B C
29-Mar-05 30-May-05 7.00
31-May-05 24-Jun-05 39.00
25-Jun-05 01-Jul-05 46.00
In Sheet 2 i got...

01-Apr 7
02-Apr 7
03-Apr 7
04-Apr 7
05-Apr 7
06-Apr 7
07-Apr 7
08-Apr 7
09-Apr 7
10-Apr 7
11-Apr 7
12-Apr 7
13-Apr 7
14-Apr 7
can i put some formula to get it done automaticaly.