Dates in gant/pivot table?

1. Dates in gant/pivot table?

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

2. Re: Dates in gant/pivot table?

I've attached an example document -- the yellow is the part I am trying to work out how to do... as I have the start date, end date
thanks

3. Re: Dates in gant/pivot table?

Formula I used is

IF(AND(date >= start_date, date <= end_date), 1, 0)

And then I colored with conditional formatting; anything greater than 0.5 gets the yellow colors. You can adjust that.

(Plus a table of dates and COUNTIFS that delivers the same thing).

I also slapped a stacked bar chart in with a date axis to show another way to display Gantt charts.

4. Re: Dates in gant/pivot table?

thats awsome ben! thanks...
have been playing a bit with it.. just need to work out how to count for type of skilled person and if its a quote or reservation

5. Re: Dates in gant/pivot table?

Hi
I am trying to make the yellow field, subtotal with a critera, i am a little lost ... , i need is department and status, invoice etc..
trying count if etc, but probably wrong...

Thanks all in advance

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1