Availability by Date

[MK_QSL]

We have projects allocated to each machine and one machine is having more than one projects allocated due to forecast….

Objective is to find out on which day which Machine is available/free to allocate future project…

Data : Something like below

Machine	Project	StartDate	FinishDate
M1	P1	09/06/2014	10/06/2014
M1	P2	12/06/2014	12/06/2014
M2	P3	08/06/2014	11/06/2014
M2	P4	15/06/2014	16/06/2014
M2	P5	20/06/2014	22/06/2014
M3	P6	08/06/2014	12/06/2014
M3	P7	18/06/2014	22/06/2014
M3	P8	24/06/2014	24/06/2014

Output required:

ReportingDate	M1	M2	M3
08/06/2014	YES	NO	NO
09/06/2014	NO	NO	NO
10/06/2014	NO	NO	NO
11/06/2014	YES	NO	NO
12/06/2014	NO	YES	NO
13/06/2014	YES	YES	YES
14/06/2014	YES	YES	YES
15/06/2014	YES	NO	YES
16/06/2014	YES	NO	YES
17/06/2014	YES	YES	YES
18/06/2014	YES	YES	NO
19/06/2014	YES	YES	NO
20/06/2014	YES	NO	NO
21/06/2014	YES	NO	NO
22/06/2014	YES	NO	NO
23/06/2014	YES	YES	YES
24/06/2014	YES	YES	NO

HERE YES means, machine is available for project on that day and NO means, it's already in use....

[#2]

You can intervalmatch reporting date to [StartDate, FinishDate]?

[MK_QSL]

Cant' use as original Database is much more complex....

[CELAMBARASAN · Accepted solution]

May be something like the attached

[MK_QSL]

Excellent... I was an inch away ... 🙂