Help with a date calculation

V

VinceW

Below is the layout of my data. What I am trying to figure out is: If the
current month and year is not = to Col C, then Col E is 0, if it is = or
beyond, Col E should = $15,122 + Col F (Previous month). Example Date is now
Oct 09, so Col E is 0, on Nov 1, 09 Col E should be = to $15,122 + $2637.91.
I would like to apply this formula to Aug 09 - Jun 10 cells in Col E.

Hope this makes sense, and any help is much appreciated.

Col C Col D Col E Col F
Planned MTD Cost Monthly Budget Adjusted Balance
July 09 $14,872.07 $15,122.00 $249.93
Aug 09 $22,278.37 $15,371.93 $(6,906.44)
Sep 09 $5,601.07 $8,215.56 $2,614.49
Oct 09 $15,098.58 $17,736.49 $2,637.91
Nov 09 $- $- $-
Dec 09 $- $- $-
Jan 10 $- $- $-
Feb 10 $- $- $-
Mar 10 $- $- $-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top