I am having trouble with a formula in excel 2007. If I have a cell say A1 = 9/17/11 and I want to populate C1 automatically with the same month and day but want the year to be the current year how do I do that. I have tried everything I can think of. Can someone please help.