i have a spreadsheet based on hiring. is it possible that when someone wants to hire somethink that i can type in the number of days they want it for, and that number can get added to todays date so i have a cell which says the date of return.
2007-01-05 04:24:36 · 4 answers · asked by L 5 in Computers & Internet ➔ Software
yes, easy
for example
c2 has todays date
c3 is where you want to put number of days hire
c4 is where you want return date
c2 and c4 are formatted to date format
formula in c4 should be
=c2+c3
2007-01-05 04:31:43 · answer #1 · answered by SeabourneFerriesLtd 7 · 0⤊ 1⤋
The above should work if you are then printing of a hard copy, (if it is live then every day you reopen the spreadsheet the return date will still be e.g. 10 days from that days date), and you could use the info in the number of hire days to calculate the rental cost (before VAT) then add on the vat (and deposit?) and you will have it all on a small piece of paper.
2007-01-05 04:57:08 · answer #2 · answered by ♣ My Brainhurts ♣ 5 · 0⤊ 0⤋
Use =today()+10 for example to have today's date plus 10 days.
2007-01-05 04:30:27 · answer #3 · answered by BigRez 6 · 1⤊ 1⤋
Go here.....http://office.microsoft.com/training/training.aspx?AssetID=RC061771061033
hope this helps
2007-01-05 04:31:54 · answer #4 · answered by Anonymous · 0⤊ 0⤋