I am needing help with creating a formula that calculates the total cost of the equipment rental for the estimated says on rent. It is based off a 28 day billing cycle. i.e. i have the equipment from 8/1/2021 - 8/30/2021, then the company would bill be a monthly rate plus two daily rates.
The...