Subtracting Two Dates

[EDJC]

I have two questions. What would the formula be for subtracting two dates to get the numbers of years, months? I cannot get my formula to work.

Also, can Excel take a telephone number such as (555)-555-5555 can place the phone number in another field such as 555-555-5555?

Thank you for any assistance you may offer, I appreciate it,
Ed

 

[Stormseed]

Regarding your first question, you can use =DATEDIF("Start Date","End Date","y").

Note: You can mention "y" in order to get difference in years, "d" in order to get the difference in days and "m" to get the difference in months.

 

[Mike Blackman]

As for the second question, does this work for you?

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

 

[EDJC]

Stormseed, thank you for the prompt response. I used your formula of
=DATEDIF(F2,C8,Y) I have the two dates defined at dates. I get the error of #NAME?

Thank you.

 

[Stormseed]

Which version of Excel do you use on your computer ?

 

[Mike Blackman]

Can you not just do a normal subtract?

=A1-B1

And format the cell to "yy" if you only want to return the year?

 

[snowblizz]

You need to put quote signs on the last variable i.e. "y" at least in 2007.

 

[Stormseed]

The exact format would be:

=DATEDIF("Start Date","End Date","y") where the start date is the reference to cell with the Starting Date and End Date would be the reference to the cell and letter y for years, m for months and d for days whould be in double quotes.

Alternatively, can you please let us know if you want to find the difference between dates in the same year ?

 

[EDJC]

I am using version Excel 2000.

I put the quotes on "Y", and it's still returning the error. I thought I could just do a normal subtract but it returns the following: 3/27/2009 - 3/27/2003 returns 2192.00

Mike, your answer to my second question worked GREAT. Thank you!

Ed

 

[Taul]

this might help
http://www.cpearson.com/excel/datedif.aspx