View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BarePaw BarePaw is offline
external usenet poster
 
Posts: 2
Default Formulas involving dates

Nevermind, I figured it out. I used the DAYS360 formula to get a number of
days, then used simple arithmetic formulas to figure out the interest
accrued and the current balance based on the number of days. It's not
perfect, but it gives a good rough estimate.