Microsoft Office Forums - View Single Post - Formula to use a date to calculate an amount $.

jeffreybrown · 05-19-2016, 03:26 PM

See how this works...

Code:

       ----A---- B ---C---- D ----E-----
   1   1/10/2016   $359.00     1/1/2016 
   2   1/15/2015   $317.00    $1,913.00 
   3   1/30/2016   $395.00              
   4   1/15/2015   $284.00              
   5   1/4/2016    $377.00              
   6   1/15/2015   $217.00              
   7   1/11/2016   $293.00              
   8   1/15/2015   $366.00              
   9   1/1/2016    $489.00              
  10   1/15/2015   $206.00