J
Juco
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
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