I am trying to create a equipment rental invoice using one spreedsheet as the
data base, I am stump on hoe to make the cell that will contain the charge of
the rental
If I use dates and in an cell I create a formula that figures out the number
os days the equipment is out
in the total charge sell I want the amount to go
so for excample I have day out, day in, day, week ,month,
total charge
05/17/10 05/18/10 32.00 128.0
384.00 ?????
How can I make the amopunt from the dates entered go into the cell??(total
charge)
Is there a rental template out there or is there a simple formula??