Total number of months.
 

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

Total number of months.
 

Hi Gary,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary" wrote in message ...
| 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
|
|

Total number of months.
 

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 wrote:
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

Total number of months.
 

Great.....Thanks a ton :)


"RichardSchollar" wrote in message
s.com...
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 wrote:
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

Total number of months.
 

Thanks Niek :)

"Niek Otten" wrote in message
...
Hi Gary,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary" wrote in message
...
| 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
|
|