One way:

A1: <start date
B1: <end date
C1: =CEILING((B1-A1)/7,1)*1.75

In article ,
"Steve" <swr1953(at)yahoo(dot)co(dot)uk wrote:

Hi
Can anyone tell me how to calculate the rental of an item

Col A would be the date the rental period started

Col B rental ended

Col C to calculate the time x £1.75 per week worked out top the nearest full
week.

TIA
Steve