P
Plasim
Hi, as seen below, I have two columns, one with dates (9-Feb-05), an
one with dollar amounts($1.00). Where you see the question mark, I a
trying to calculate the total dollars between the "from" and "to
dates using the data in the 2 columns. Does anyone know a formula fo
this?
Thanks
FROM TO TOTAL
Week 1 3-Mar-05 25-Feb-05 ?
Week 2 24-Feb-05 18-Feb-05 ?
Week 3 17-Feb-05 11-Feb-05 ?
Week 4 10-Feb-05 4-Feb-05 ?
Data
9-Feb-05 $1.00
12-Feb-05 $2.00
1-Mar-05 $3.00
20-Feb-05 $5.00
5-Feb-05 $4.0
one with dollar amounts($1.00). Where you see the question mark, I a
trying to calculate the total dollars between the "from" and "to
dates using the data in the 2 columns. Does anyone know a formula fo
this?
Thanks
FROM TO TOTAL
Week 1 3-Mar-05 25-Feb-05 ?
Week 2 24-Feb-05 18-Feb-05 ?
Week 3 17-Feb-05 11-Feb-05 ?
Week 4 10-Feb-05 4-Feb-05 ?
Data
9-Feb-05 $1.00
12-Feb-05 $2.00
1-Mar-05 $3.00
20-Feb-05 $5.00
5-Feb-05 $4.0