software

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

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 do
the following:

=IF(AND((B1-A1)lt;4,(B1-A1)gt;=0),1.75,ROUND(((B1-A1)/7),0)*1.75)

Hope that helps.--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
View this thread: www.excelforum.com/showthread...hreadid=534975One way:

A1: lt;start dategt;
B1: lt;end dategt;
C1: =CEILING((B1-A1)/7,1)*1.75

In article gt;,
quot;Stevequot; lt;swr1953(at)yahoo(dot)co(dot)ukgt; wrote:

gt; Hi
gt; Can anyone tell me how to calculate the rental of an item
gt;
gt; Col A would be the date the rental period started
gt;
gt; Col B rental ended
gt;
gt; Col C to calculate the time x £1.75 per week worked out top the nearest full
gt; week.
gt;
gt; TIA
gt; Steve

I may have misinterpreted your quot;to the nearest full weekquot; - 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

In article gt;,
JE McGimpsey gt; wrote:

gt; One way:
gt;
gt; A1: lt;start dategt;
gt; B1: lt;end dategt;
gt; C1: =CEILING((B1-A1)/7,1)*1.75
gt;
gt; In article gt;,
gt; quot;Stevequot; lt;swr1953(at)yahoo(dot)co(dot)ukgt; wrote:
gt;
gt; gt; Hi
gt; gt; Can anyone tell me how to calculate the rental of an item
gt; gt;
gt; gt; Col A would be the date the rental period started
gt; gt;
gt; gt; Col B rental ended
gt; gt;
gt; gt; Col C to calculate the time x £1.75 per week worked out top the nearest
gt; gt; full
gt; gt; week.
gt; gt;
gt; gt; TIA
gt; gt; Steve