Post by teddy on Oct 30, 2017 18:13:53 GMT
Peeps, just before I hibernate for the winter, I want to do my AC housekeeping. I have concerns that I'm not getting the repayments I should be, and want to find out my actual interest rate pa.
I've downloaded Excel files for each of my AC accounts, 30 day, GBBA, GEIA etc for 1st Jan to 30th Oct 2017. I know how to use the filter and am moderately competent with fomulas. However, the date cells have date, time and other bumpf in them which presumably makes XIRR difficult. Is there anyway to clean up the date field in one fell swoop so that I can just have two columns, one with date, one with my interest payments?
I've downloaded Excel files for each of my AC accounts, 30 day, GBBA, GEIA etc for 1st Jan to 30th Oct 2017. I know how to use the filter and am moderately competent with fomulas. However, the date cells have date, time and other bumpf in them which presumably makes XIRR difficult. Is there anyway to clean up the date field in one fell swoop so that I can just have two columns, one with date, one with my interest payments?
