I have a report I am working on and my focus in on three columns. One with Commitment Dates, the next column is the 2012 Status, and the third column is the 2013 Status. I need to create a formula that looks at the Commitment Date and returns either "Committed" or "Non-Committed". Obviously if the commitment date is within the year 2013, it would return "Non-Committed" in the 2012 Status Column. Please Help!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Committed Effective Date[/TD]
[TD]2012 Status[/TD]
[TD]2013 Status[/TD]
[/TR]
[TR]
[TD]1/1/2013[/TD]
[TD]Non-Committed[/TD]
[TD]Committed[/TD]
[/TR]
[TR]
[TD]8/1/2010[/TD]
[TD]Committed[/TD]
[TD]Committed[/TD]
[/TR]
[TR]
[TD]7/25/2013[/TD]
[TD]Non-Committed[/TD]
[TD]Committed[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Committed Effective Date[/TD]
[TD]2012 Status[/TD]
[TD]2013 Status[/TD]
[/TR]
[TR]
[TD]1/1/2013[/TD]
[TD]Non-Committed[/TD]
[TD]Committed[/TD]
[/TR]
[TR]
[TD]8/1/2010[/TD]
[TD]Committed[/TD]
[TD]Committed[/TD]
[/TR]
[TR]
[TD]7/25/2013[/TD]
[TD]Non-Committed[/TD]
[TD]Committed[/TD]
[/TR]
</tbody>[/TABLE]