Choosing one item of data from a loan amortisation schedule based on date

Hi, I am using Excel 2007. I have a loan amortisation schedule and I want to be able to select information from within that schedule relative to any date I select (not necessarily a date on the schedule) - is this possible. For example in the attached schedule, if I input a date in cell N2 and I want to display the Principal (or any other component of the schedule) closest to that date in cell N4, how would I do this? Many thanks

Thanks Sktneer, I did change the format of cell N2 to date and but when I load a date the loan principal selected relates to the previous date, not the date selected - not sure why.
Is it possible to load a formula that selects a loan principal (or any other data from that table) that relates to any date that fits between two date ranges? Cheers

That's because your date formats aren't consistent. Once you enter the date into N2, copy and paste it into the corresponding cell in Column C that matches. Then the result in N4 will update to the correct date. Just make your date formats consistent.

Hi Hoyasaxa,

Thanks for your input - this seems to be working albeit has uncovered another problem.

All the dates in cell N2 and also in the amortisation schedule are formatted the same in terms of date, type & locale. Locale is English NZ as I live in NZ.
In NZ we write a date in this format dd/mm/yyyy - which this calculation does not recognise. To make the formula work I have to load mm/dd/yyyy. Do you know how I can fix this as I really need it to work using dd/mm/yyyy? Many thanks