I'm working on an all encompassing, fully automated budget spanning multiple workbooks. My question involves a very specific portion of this though. I have a list of dated transactions all in order, and one of my helper columns converts the date to the month's text. =TEXT(A1,"mmm") For one of my formulas, I need to make sure the current partial month isn't included. The easiest way would seem to be to have this helper column be blank if it's the last value listed. For example, imagine the following list in columns A & B. How would you make it so March doesn't show up until you enter a non-March date below it in Column A?

1/1/2015 Jan
1/10/2015 Jan
1/15/2015 Jan
1/20/2015 Jan
1/25/2015 Jan
2/1/2015 Feb
2/5/2015 Feb
2/20/2015 Feb
2/25/2015 Feb
2/28/2015 Feb
3/1/2015 Mar
3/3/2015 Mar
3/10/2015 Mar
3/20/2015 Mar

Thanks in advance!