calculate year and month
 

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Check out thisw link on the DateDif function...

http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson


"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Use the DATDIF() function. If the dates are in A1 and A2 then:
=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months"
will display:
1 years, 5 months

--
Gary's Student
gsnu200703


"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Or, you can do =days360(A2,B2,FALSE)
Assuming A2 is the start and B2 is the end.
May need to add Analysis ToolPak from the Tools/AddIns option.

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

This helped much. Can I add the number of days to this also?

"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Hi Michelle

Yes you can, the argument for the days within a year is "yd" so just add a
formula with that argument at the end.

HTH
Jean-Guy

"michelle" wrote:

This helped much. Can I add the number of days to this also?

"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Thank you again...I figured it out after I asked.

"pinmaster" wrote:

Hi Michelle

Yes you can, the argument for the days within a year is "yd" so just add a
formula with that argument at the end.

HTH
Jean-Guy

"michelle" wrote:

This helped much. Can I add the number of days to this also?

"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)

calculate year and month
 

Rather than "yd", I think you may want "md" for days excluding months and
years?
--
David Biddulph

"pinmaster" wrote in message
...
Hi Michelle

Yes you can, the argument for the days within a year is "yd" so just add a
formula with that argument at the end.

"michelle" wrote:

This helped much. Can I add the number of days to this also?

"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

"michelle" wrote:

I have a start date and an end date. I want to show the number of
years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would
show 1
yr 6 mos)

calculate year and month
 

Hi,

I had raised a similar post but got the answer from you.

thanks
krishna



"pinmaster" wrote:

Hi,

Try this:

=DATEDIF(start_date,end_date,"y")&IF(DATEDIF(start _date,end_dated,"y")1,"
years "," year
")&DATEDIF(start_date,end_date,"ym")&IF(DATEDIF(st art_date,end_date,"ym")1,"
months "," month")

HTH
Jean-Guy

"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)