Hi

can i put some formula to get it done automaticaly.

not sure on what "it" is, ie the thing you want to get done automatically
....
i can't see how 7 (whatever's) per day for April relate at all to
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

if you'ld like to explain your data and what you want to achieve with a few
more words i'm sure we can assist.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"darsg" wrote in message
...
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.