car hire rental spreadsheet

**leeb02** · 05-12-2007, 10:26 AM

Hi,

basically i am doing a car hire rental spreadsheet for my college coursework. in one sheet i have prices of cars available by week and by day. in another sheet i want to be able to input the start and end date of the rental and then for it to calculate how many weeks and days this is, then to calculate the total cost. not too sure how i would do it.

hope someone can help,

thanks, Lee

**starguy** · 05-12-2007, 10:33 AM

Originally Posted by leeb02

Hi,

basically i am doing a car hire rental spreadsheet for my college coursework. in one sheet i have prices of cars available by week and by day. in another sheet i want to be able to input the start and end date of the rental and then for it to calculate how many weeks and days this is, then to calculate the total cost. not too sure how i would do it.

hope someone can help,

thanks, Lee

Please read the forum rules. Don't post single question on multiple forums.

And please attach a sample file in zip format.

**Simon Lloyd** · 05-12-2007, 10:37 AM

Lee, we are unable to help directly with coursework/homework as you will appreciate it's a learning curve for you to research the things you need and try to work some examples yourself - that said here are a few links that will help you understand calculation of dates!
Chip Pearson's Date & Time
Exceltip Avoid Neg values when calculating dates
ExcelUser help on datesAll these are specific to your question, once you have something worked out and have a specific bug with it then post back and we will point you in the right direction.

**Teethless mama** · 05-12-2007, 01:43 PM

Originally Posted by leeb02

Hi,

basically i am doing a car hire rental spreadsheet for my college coursework. in one sheet i have prices of cars available by week and by day. in another sheet i want to be able to input the start and end date of the rental and then for it to calculate how many weeks and days this is, then to calculate the total cost. not too sure how i would do it.

hope someone can help,

thanks, Lee

I don't do homework

**arif12** · 01-31-2017, 01:28 AM

Originally Posted by leeb02

Hi,

basically i am doing a new Luxury car hire in New Zealand spreadsheet for my college coursework. in one sheet i have prices of cars available by week and by day. in another sheet i want to be able to input the start and end date of the rental and then for it to calculate how many weeks and days this is, then to calculate the total cost. not too sure how i would do it.

hope someone can help,

thanks, Lee

Hello
you can use these formulas
Spreadsheet Formulas
Cell Formula
D30 =TEXT(C30,"mmm-dd")
D31 =IF(C31="","",TEXT(C31,"mmm-dd"))
D32 =TEXT(C32,"mmm-dd")