Making a dynamic ranged print area that also only prints within a date range

[david_j_p]

I'm trying to make a dynamic print area that works like a dynamic range but also has condition that checks the data against a starting and finishing date
and only prints the rows that are within these dates.

Is this possible without VBA or Macros

My dynamic range is like this:
=OFFSET(INDEX('Data Entry'!$A$2,0,0,COUNTA('Data Entry'!$A:$A)-COUNTA('Data Entry''!$A$1:$A$1),COUNTA('Data Entry''!$1:$1))

My date range will reference:
INDEX(Data_Entry,,1),">="&Period_Start,INDEX(Data_Entry,,1),"<="&Period_Finish)

Index Data_Entry 1 is my date column

Period_Start and Period_Finish just reference the start date cell and the finish date cell.


Do I make a Named Range that is dynamic for just the size, and a print area that does the date check on the Named Range, and will print just the rows with that are within the date range?
This is what I have been trying to do with no success!

Any help would be much appreciated!!!

 

[david_j_p]

I have an xlsx file to attach, but haven't yet worked out how to attach!

I tried a reply, with a "Go advanced" but there is no attachment Icon??

 

[david_j_p]

SOLVED!!!

Dynamic Range - Data_Entry:
=OFFSET(INDEX('Data Entry'!$A$2,0,0,COUNTA('Data Entry'!$A:$A)-COUNTA('Data Entry''!$A$1:$A$1),COUNTA('Data Entry''!$1:$1))


Print_Area:

=OFFSET($A$1,MATCH(1,INDEX((INDEX(Data_Entry,,1)>=Period_Start)*(INDEX(Data_Entry,,1)<=Period_Finish),),0),,COUNTIFS(INDEX(Data_Entry,,1),">="&Period_Start,INDEX(Data_Entry,,1),"<="&Period_Finish),9)