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.
 

peter.abing

New member
Joined
Oct 24, 2012
Messages
34
Reaction score
0
Points
0
Use this formula:
=VALUE(MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)+1)
and format the result as a date.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=DATE(YEAR(TODAY),MONTH(A1),DAY(A1))
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Bob, shouldn't it be today() instead of today ( without brackets) ?
 
Top