Creating a Calendar

[GerryBriant]

My conundrum is..
On sheet 1, I have a 2 columns (A & B) containing multiple dates.
Column A' is 'Task start date' & Column 'B' is 'Task end date'.
On sheet 2, Row 1 contains incremental dates.
The outcome I am trying to work out is
Sheet 1 start date (A2) = 01/01/2018, end date (B2) = 03/01/18
Sheet 2 I would expect (or am hoping) to see the following against the column dates
A1 is 01/01/2018, & A2 = 1, B1 is 02/01/2018, & B2 = 1, C1 is 03/01/208, & C2 =1, D1 is 04/01/2018 & D2 = 0 (or blank), E1 is 05/01/2018 & E2 = 0 (or blank) etc.
PS date formats are UK
Any suggestions or guidance?

 

[FormR]

I have incorporated your suggestion in a nested formulae (to select against a employee

Hi, If A.Gibbs, for example, can only appear once on sheet1 then there will be a better alternative - but assuming that is not the case you can try:

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J
1		01/01/2018	02/01/2018	03/01/2018	04/01/2018	05/01/2018	06/01/2018	07/01/2018	08/01/2018	09/01/2018
2	A. Bugg	0	0	1	1	1	0	0	0	0
3	A. Gibbs	1	1	1	0	0	0	0	0	0
Sheet2

Cell Formulas
Range	Formula
B2	=0+(COUNTIFS(Sheet1!$B:$B,"<="&B$1,Sheet1!$C:$C,">="&B$1,Sheet1!$A:$A,$A2)>0)

Excel 2013/2016
	A	B	C
1	Resource	Activity Start Date	Activity End Date
2	A. Gibbs	01/01/2018	03/01/2018
3	A. Bugg	03/01/2018	05/01/2018
Sheet1

 

[GerryBriant]

Thank You FormR,
I have incorporated your suggestion in a nested formulae (to select against a employee - {=SUM(IF(Sheet1!$A:$A=$A6,(0+(COUNTIFS(Sheet1!$D:$D,"<="&H$3,Sheet1!$E:$E,">="&H$3)>0))))} but I am not getting the expected result...

Sheet1

Resource (Select from Dropdown)	Activity Start Date	Activity End Date
A. Gibbs	01/01/18	03/01/18

<tbody>
</tbody>

Sheet2

	BH	Tue	Wed	Thu	Fri	Sat	Sun	Mon
Employee	01	02	03	04	05	06	07	08
A. Bugg	3	3	3	3	3	3	3	0
A. Edwards	1	1	1	1	1	1	1	0
A. Gibbs	1	1	1	1	1	1	1	0

<tbody>
</tbody>

 

[GerryBriant]

You Sir, are a genius.... Ive been working on that for ages (doing the if name at the start!!).

Many thanks