Date

Aaron · Feb 21st, 2002, 12:36 PM

I have a specific date (Jan 19, 2002) and I want to add three (3) years to that date to get (Jan 19, 2005). Would someone please offer a formula suggestion? Thank you -asa

Aladin Akyurek · Feb 21st, 2002, 12:53 PM

=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))

or

=EDATE(A2,12*3) [ requires the Analysis Toolpak ]

Aladin

Mark W. · Feb 21st, 2002, 12:54 PM

=EDATE(A1,36)

Note: The EDATE function is a part of the Analysis ToolPak.

Joe Was · Feb 21st, 2002, 01:05 PM

Try:

=DATE(YEAR(B12)+3,MONTH(B12),DAY(B12))

JSW

Aaron · Apr 18th, 2002, 02:35 PM

I am sorry it took me so long to reply, but thank you all. I used the formulas you guys gave me, and forgot to post Thanks. -asa

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 12:36 PM	#1
Aaron Board Regular Join Date: Feb 2002 Location: Texas Posts: 233	I have a specific date (Jan 19, 2002) and I want to add three (3) years to that date to get (Jan 19, 2005). Would someone please offer a formula suggestion? Thank you -asa

Feb 21st, 2002, 12:53 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)) or =EDATE(A2,12*3) [ requires the Analysis Toolpak ] Aladin

Feb 21st, 2002, 12:54 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=EDATE(A1,36) Note: The EDATE function is a part of the Analysis ToolPak.

Feb 21st, 2002, 01:05 PM	#4
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	Try: =DATE(YEAR(B12)+3,MONTH(B12),DAY(B12)) JSW

Apr 18th, 2002, 02:35 PM	#5
Aaron Board Regular Join Date: Feb 2002 Location: Texas Posts: 233	I am sorry it took me so long to reply, but thank you all. I used the formulas you guys gave me, and forgot to post Thanks. -asa