S
S S
I have 2 sets of cells.
Set 1. C7,D7, E7 this is for start DD/MM/YYYY
Set 2. G7, H7,I7 this is for to end DD/MM/YYYY
The above represents weekly rental for property eg start 26/06/2006 end
03/07/2006 so one week rental.
In cell M7 I need a formula for the above to show £200 for that week
However if they rent for 2 weeks eg 26/06/06 to 10/07/2006 then also M8 to
show £200.
That would give me 2 entries of £200 one for each week, this is then
totalled further down the page.
The year YYYY I dont think is relevent and I somehow need to work out if one
week or two from the dates
and have the formula enter a £200 or 2 x £200 in the apprpriate cells.
Any help appreciated.
Set 1. C7,D7, E7 this is for start DD/MM/YYYY
Set 2. G7, H7,I7 this is for to end DD/MM/YYYY
The above represents weekly rental for property eg start 26/06/2006 end
03/07/2006 so one week rental.
In cell M7 I need a formula for the above to show £200 for that week
However if they rent for 2 weeks eg 26/06/06 to 10/07/2006 then also M8 to
show £200.
That would give me 2 entries of £200 one for each week, this is then
totalled further down the page.
The year YYYY I dont think is relevent and I somehow need to work out if one
week or two from the dates
and have the formula enter a £200 or 2 x £200 in the apprpriate cells.
Any help appreciated.