Hi, everyone,

I'm not sure how to write an "If" function for dates and amounts and I was hoping to get some help. So here's my scenario:

I have a spreadsheet in which I keep track of amounts logged every day. These amounts may increase or decrease gradually, so imagine for example that:

Column A: Entire Year from 1/1/2013 to 12/31/2013
Column B: Fluctuating Amounts

Based on this information, I have another table (Starting in column D) that has the 12 months (January, February, March, etc.) in Column D, and Amount in column E. So, what I want each cell in column E, depending on the month is the following rule: If, for example, today falls in January, display today's amount; if today is not in January and January has already passed, show amount logged for January 31 (in other words, the last day of that month); if January hasn't happened, show $0.00.

I hope this makes sense, and I appreciate any help I can get in this! I've attached a sample of the spreadsheet, but it does not have any formulas; it just shows what I want it to do (I also added a few comments, in case they help), so you all have an idea of what I want to do.

Thanks!