On my income statement, I have a column called "Current Year to Date" and my comparative column for the prior year is for the full year, not the comparable period. ie if the first column is "Six months to June 30th", the comparative column for the prior year would be for the "12 months to December 31st". My problem is in finding a formula for the date of the prior year end that will not change every time I select a different period. How do I "lock in" that Dec 31, 2007 date?