Total number of months.

[Gary]

Hi Experts,

What i want to do is calculate the number of months between 2 dates.

For example:

Date of joining - 01-Aug-2004
Today's Date - 21-Dec-2006

1. What would be the formula for calculating the number of months.

2. What would be the formula for calculating the number of years.

3. What would be the formula for calculating the number of days.

thanks in advance for any help.

Gary

 

[Niek Otten]

Hi Gary,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Experts,
|
| What i want to do is calculate the number of months between 2 dates.
|
| For example:
|
| Date of joining - 01-Aug-2004
| Today's Date - 21-Dec-2006
|
| 1. What would be the formula for calculating the number of months.
|
| 2. What would be the formula for calculating the number of years.
|
| 3. What would be the formula for calculating the number of days.
|
| thanks in advance for any help.
|
| Gary
|
|

 

[RichardSchollar]

Hi Gary

1.=DATEDIF(DateOfJoining,TODAY(),"m")
2.=DATEDIF(DateOfJoining,TODAY(),"y")
3.=DATEDIF(DateOfJoining,TODAY(),"d")

Replace DateOfJoining with whatever cell ref holds your date (ie
1/Aug/2004).

The last one is very simple as it is really only =TODAY()-"01Aug2004".
This will give you the number of days between the two dates.

Hope this helps!

Richard

 

[Gary]

Great.....Thanks a ton

Hi Gary

1.=DATEDIF(DateOfJoining,TODAY(),"m")
2.=DATEDIF(DateOfJoining,TODAY(),"y")
3.=DATEDIF(DateOfJoining,TODAY(),"d")

Replace DateOfJoining with whatever cell ref holds your date (ie
1/Aug/2004).

The last one is very simple as it is really only =TODAY()-"01Aug2004".
This will give you the number of days between the two dates.

Hope this helps!

Richard

 

[Gary]

Thanks Niek