If you want a positive result, subtract start from finish, rather than vice
versa.
--
David Biddulph

"dlw" wrote in message
...
format two cells as date (mm/dd/yy) and enter start date in one, and end
date
in the other. In a third cell, subtract the end date cell from the start
date cell, that will result in a number of days, then divide by 7 to get
weeks.

"Humphrey" wrote:

Hi,
Is there a way to calculate an amount continuialy (weekly) until an end
date
is put in.

The scenario is that i want to see the weekly hire cost of some equipment
however various items come and go on/off hire at different times?



Many Thanks

H