Formula to work out equipment hire based on a minimum hire period.

mpaino · #1 07-13-2016, 11:50 AM

That's about it, every time I hire a piece of equipment I need to keep it for 4 weeks, as simple as that, but I couldn't work it out with formulas.
Many thanks

c991257 · #2 07-15-2016, 09:13 AM

Something like this?

It assumes that the hire date is a Monday.

/Møller

mpaino · #3 07-18-2016, 03:44 AM

Hi c991257,
Not quite that as I calculate the equipment required on a weekly basis. From that I then need to keep the equipment for 4 weeks.
Thanks anyway

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need formula to determine minimum quantity needed per price	mbking	Excel	2	02-10-2015 01:46 PM
Count the common time period (month) between two date period of time	Barni	Excel	6	08-15-2014 07:52 AM
Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl	glen123	Excel	7	07-28-2014 07:29 AM
How do I calculate planned work for a given time period	bumpui	Project	1	06-04-2014 06:37 AM
Managing equipment and person operating equipment	ProfessorGilligan1	Project	1	04-12-2012 12:29 PM