In my spread sheet I maintain a great deal of information regarding our
fleet, I would like a way for the spread sheet to automaticaly calculate the
payoff amount based on either "TODAYS" date or a date that I imput. Currently
I have set up the "LOAN CALULATOR" spread sheet for each loan and I have it
hyperlinked to the account number on the spread sheet but it still doesn't
give me the exact amount for that day with out doing a whole bunch of
additional calculations. I am just a fleet manager not an accountant so I
need all the help I can get