Forum Discussion
Formula Help!!
Good afternoon. I am somewhat knowledgeable in excel but I am having trouble writing a formula. I have a rental company with a large quantity of units along with several types of units. I do contracts with events that may require 20-100 or more units and I am trying to write a formula that will tell me what I have available for a given date range so I don't overbook and can't seem to get one to work. If it matters, the start day and end days aren't always the same day of the week, so these may be anywhere from 1 - 30 day contracts. Thanks in advance for any help!
Darren
8 Replies
Hello,
that question is really hard to answer without seeing how your data is organised. Do you have several units of the same model? How is the data stored?
Can you post a sample file with just a few items that helps us understand your data? Just a few types of units and a few rentals in the same setup as your original data would be helpful.
