Formula to work out equipment hire based on a minimum hire period.
Hi gebobs, thanks for the reply.
In the spreadsheet attached you can see the number of equipment required by week. In week 27 I need to 1, and week 28 I need 10. However, once a piece of equipment is hired, then I need to keep it for 4 weeks. So the equipment I hire in week 27 I can only send it back in week 31, but in week 28 I have to hire another 9, which I need to keep for 4 weeks....and so on.
I don't know how to do it or if it can be done with formulas without using a macro.
Any help is much appreciated.
Thanks
|