Calcalation

[Steve]

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

 

[Ikaabod]

Try:

=ROUND(((B1-A1)/7),0)*1.75

Note that if they rent for less than 4 days it will result in zero.

If you want it to default to 1.75 if they rent for less than 4 days d
the following:

=IF(AND((B1-A1)<4,(B1-A1)>=0),1.75,ROUND(((B1-A1)/7),0)*1.75)

Hope that helps

 

[JE McGimpsey]

One way:

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

 

[JE McGimpsey]

I may have misinterpreted your "to the nearest full week" - I was
assuming one rounds up to the full week. To limit it to the last full
week, use FLOOR() instead of CEILING().

To round to the nearest full week,

=ROUND((B1-A1)/7,0)*1.75