Hi, I am trying to create a chart/report that shows me the following information
I have for example suppliers 1 2 3 4 etc..
they are booked on 1/7/2014 for 3 days.
All i have is the start date.
How do make a formula to assume they are also booked on 2/7/2014 and 3/7/2014
Ie
supplier 1 start 1/7 booked for 3 days
supplier 2 start 2/7 booked for 2 days
supplier 3 start 3/7 booked for 10 days
I am thinking the booked value is = 1 and not booked = 0
this way can see how many suppliers are booked on 1 day.. easy on the above, but in lots of lines- excel!
thanks for help
Bookmarks