# Find today's value

#### excel_solutions

##### New Member
 Repayment Date Total Rpmt Amount My Rpmt Amount column P column Q 3/28/2017 0.00 0.00 9/28/2017 0.00 0.00 3/28/2018 5,500,000.00 5,500,000.00 9/28/2018 5,500,000.00 5,500,000.00 3/28/2019 6,500,000.00 6,500,000.00 9/28/2019 6,500,000.00 6,500,000.00 3/28/2020 6,500,000.00 6,500,000.00 9/28/2020 6,500,000.00 6,500,000.00 3/28/2021 6,500,000.00 6,500,000.00 9/28/2021 6,500,000.00 6,500,000.00 3/28/2022 5,000,000.00 5,000,000.00 9/28/2022 5,000,000.00 5,000,000.00 3/28/2023 5,000,000.00 5,000,000.00 Total 65,000,000.00 65,000,000.00

<tbody>
</tbody>

=(SUM(OFFSET(P9,(MATCH(TODAY(),\$P\$9:\$P\$21,1)),2):R21))/1000000

it is giving #N/A error

so basically what i want is by matching today's date with repayment date, it gives me the outstanding amount.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

##### MrExcel MVP
This data is apparently located in P8:R22, headers and the total row included.

Given this sample, what is the expected result? by the way, the today's date is not available at all in column P of the data!

Replies
7
Views
2K
Replies
3
Views
724
Replies
1
Views
674
Replies
1
Views
228
Replies
0
Views
609

1,191,358
Messages
5,986,187
Members
440,009
Latest member
VARGAST

### 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