date calculation
 

How would i get this to work for me?

dd mm yy (minus) dd mm yy (day month & year in seperate cells) say
A1,B1,C1 - D1,E1,F1
It is a booking form so should give either 1 or 2 for weeks (preferred) or
7 or 14 for nights
I would then multiply this by the weekly/daily rate (in cell A2) to give a
total rental cost in cell B2.
My knowledge is very very basic but adjusting a previous formula I had,
would this work?

in B2 DATE(A1,B1,C1)-(D1,E1,F1)*A2

thanks

Hi

When entries are in same order as you did give, then rather
=(DATE(C1,B1,A1)-DATE(F1,E1,D1))*A2


Arvi Laanemets


"Juco" wrote in message
k...
How would i get this to work for me?

dd mm yy (minus) dd mm yy (day month & year in seperate cells) say
A1,B1,C1 - D1,E1,F1
It is a booking form so should give either 1 or 2 for weeks (preferred)
or
7 or 14 for nights
I would then multiply this by the weekly/daily rate (in cell A2) to give a
total rental cost in cell B2.
My knowledge is very very basic but adjusting a previous formula I had,
would this work?

in B2 DATE(A1,B1,C1)-(D1,E1,F1)*A2

thanks