Adjust Formula

[dunmore83]

Hi,

I have the following formula;

{=IF(ROWS($D$26:D26)<='Injection-History-Records'!$G$1,MIN(IF(1-ISNUMBER(MATCH('Injection-History-Records'!$G$18:$G$1855,$D$24:D25,0)),IF(ISNUMBER('Injection-History-Records'!$G$18:$G$1855),'Injection-History-Records'!$G$18:$G$1855))),"")}

Cell A1 is a date i.e. 10/Aug/16
Cell A2 is a date i.e. 11/Dec/16

Injection History Records worksheet - range D18:D1855 are dates.

I need to adjust the formula above to only return the numbers if the dates in range D18:D1855 are equal to or greater then Cell A1 & equal to or less than Cell A2.

Any helpers ???

Thanks

 

[Aladin Akyurek]

Try...

{=IF(ROWS($D$26:D26)<='Injection-History-Records'!$G$1,MIN(IF(1-ISNUMBER(MATCH('Injection-History-Records'!$G$18:$G$1855,$D$24:D25,0)),IF(ISNUMBER('Injection-History-Records'!$G$18:$G$1855),IF('Injection-History-Records'!$G$18:$G$1855>=$A$1,IF('Injection-History-Records'!$G$18:$G$1855<=$A$2,'Injection-History-Records'!$G$18:$G$1855))))),"")}