This is my first post, so please excuse if this doesn’t make sense or if I am doing this wrong.
I have a list of Payment dates, (8/1/16, 9/1/16, 10/1/16, + 30 years). How do I find the current month/year? Im trying to have my formula find the current month/year and grab the data from a different column from the row that the current month is in and copy that data to a different cell.
For example:
Column C: Column L:
Row 13: Payment Date Cumulative Interest
Row 15: 8/1/2016 $4359
Row 16: 9/1/2016 $8712
Row 17: 10/1/2016 $13059
Row 18: 11/1/2016 $17399
Row 19: 12/1/2016 (current) $21732
I want to find today’s current month/year and grab the value in column L in the same row and copy it to L9. (see attached worksheet)
I do not want to do a VBA/Macro - system crashes every time I try these.
Bookmarks