calculating 2days given 2 dates

[jimcuk]

Hi Folks

Mostly got this working, however there has been a change to the scenario.

trailers called "All others" now have only 1 free day
The other two types have 2 free days.
I am calculating the on hire date in column d with
[Select Code] copy to clipboard

Please Login or Register  to view this content.

I am selecting the cost in column H with

Please Login or Register  to view this content.

as suggested by Dan from this post
http://www.excelforum.com/showthread...6618&p=4372155

I cant figure out how to incorporate the 1 and 2 free date into the above formula
any help appreciated
file attached

[djbomaha]

Hi jimcuk,

Here is a formula that I think works. It is revised from the other thread to incorporate the portion for calculating days Jim Topley posted and then I made it so it always subtracts 1 or 2 days, depending on the type of trailer that is specified.

Please Login or Register  to view this content.

Hope it helps,

Dan

[jimcuk]

Hi Dan thanks
seems to be calculating 2 days short for each type ?

[djbomaha]

After looking at the sheet you posted again, it looks like you are accounting for the free days in your equations in Column D. If that is true, then the equation in Column F gets simplified to from what I can tell.

Please Login or Register  to view this content.

[jimcuk]

Hi Dan
thanks again, don't know if its my accounting in column d but it is still leaving me one day short.
for instance inbound 25/4 with standard trailer the 25th and 26th are free day so on hire from the 27th(inclusive) should give 8 days but I am getting 7 days

[djbomaha]

To make the formula inclusive, 1 will need to be added to the formula. It has been updated below:

Please Login or Register  to view this content.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[jimcuk]

Fantastic Dan
Thanks very much for this.

[jimcuk]

Apologies Ben title changed