Hi everyone I am new to this forum but require some help so what ever you can do will be much appreciated.

First I need to describe what I want to achieve:

I work in a company that supplies materials over a hire period, so the first column in my spreadsheet will be the items description (a2), followed by the Hire period (b2) which is the first problem I have come across as I cannot format the cell to be weeks. The next cell is the start date for hire (c2) followed by todays date (d2). The next cell is the difference between these two dates (e2) where i have used the formula: =+INT(DATEDIF(C2,D2,"D")/7)&" week(s) "&MOD(DATEDIF(C2,D2,"D"),7)&" day(s)"

I want the next cell to show me the how much E2 is over B2 which I would then multipy by an over hire charge rate (g2) giving me a value to charge (h2).

Any help in this matter will be much appreciated