time difference

XL_Rookie · Mar 8th, 2002, 09:10 AM

when subtracting two dates, i want to get the answer in months. What cell format can I use for that or do I need to work it out manually?

Thanks

Mark W. · Mar 8th, 2002, 09:15 AM

=DATEDIF(A1,A2,"m")

XL_Rookie · Mar 8th, 2002, 09:18 AM

I tried your suggestion, I dont think I'm getting it right.

with the dates 07/15/1999 and 09/18/2003
the result is 2/00 which makes no sense.

Thanks

Mark W. · Mar 8th, 2002, 09:21 AM

Quote:

On 2002-03-08 08:18, XL_Rookie wrote:
I tried your suggestion, I dont think I'm getting it right.

with the dates 07/15/1999 and 09/18/2003
the result is 2/00 which makes no sense.

Thanks

Format the cell containing DATEDIF with a non-date number format (e.g., General, 0, etc.)

XL_Rookie · Mar 8th, 2002, 09:28 AM

gotcha

thank you

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

Mar 8th, 2002, 09:10 AM	#1
XL_Rookie New Member Join Date: Mar 2002 Posts: 5	when subtracting two dates, i want to get the answer in months. What cell format can I use for that or do I need to work it out manually? Thanks

Mar 8th, 2002, 09:15 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=DATEDIF(A1,A2,"m")

Mar 8th, 2002, 09:18 AM	#3
XL_Rookie New Member Join Date: Mar 2002 Posts: 5	I tried your suggestion, I dont think I'm getting it right. with the dates 07/15/1999 and 09/18/2003 the result is 2/00 which makes no sense. Thanks

Mar 8th, 2002, 09:28 AM	#5
XL_Rookie New Member Join Date: Mar 2002 Posts: 5	gotcha thank you