Format Cell in Months

minnie · Apr 26th, 2002, 09:20 AM

Subtracting two dates and would like the answer to be in months.

Mark W. · Apr 26th, 2002, 09:33 AM

=DATEDIF(A1,B1,"M")

Joe Was · Apr 26th, 2002, 09:36 AM

=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"ym")& " months")

This will give only the months portion of the between date. It will not convert the years to month though.

Like: 2 years 3 months will = 3 months, not 27 months!

And:

=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"m")& " months")

will give you your 27 months for 2 years and 3 months. Hope this helps. JSW

[ This Message was edited by: Joe Was on 2002-04-26 08:40 ]

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

Apr 26th, 2002, 09:20 AM	#1
minnie New Member Join Date: Apr 2002 Posts: 28	Subtracting two dates and would like the answer to be in months.

Apr 26th, 2002, 09:33 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=DATEDIF(A1,B1,"M")

Apr 26th, 2002, 09:36 AM	#3
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"ym")& " months") This will give only the months portion of the between date. It will not convert the years to month though. Like: 2 years 3 months will = 3 months, not 27 months! And: =IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"m")& " months") will give you your 27 months for 2 years and 3 months. Hope this helps. JSW [ This Message was edited by: Joe Was on 2002-04-26 08:40 ]