#### dunmore83

##### Well-known Member
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

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

##### MrExcel MVP
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))))),"")}

Replies
1
Views
1K
Replies
3
Views
412
Replies
0
Views
659
Replies
11
Views
1K
Replies
3
Views
705

1,191,092
Messages
5,984,593
Members
439,896
Latest member
SquareCare

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back