View Single Post
  #1   Report Post  
Juco
 
Posts: n/a
Default 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