Date Formula

artgoede

New member
Joined
Feb 20, 2013
Messages
4
Reaction score
0
Points
0
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.
 
Use this formula:
=VALUE(MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)+1)
and format the result as a date.
 
Try

=DATE(YEAR(TODAY),MONTH(A1),DAY(A1))
 
Bob, shouldn't it be today() instead of today ( without brackets) ?
 
Back
Top