I need to calculate the number of months from today to 2008 Dec 31, and
put that in an Excel cell with equal sign, and fraction of a month is
divided by 31.

How do I do that?

PS: I am not looking for dedicated VBA script module.

Thank you.

It depends how you define the difference between months, A simple answer
which is close to what you want is
=(DATE(2008,12,31)-TODAY())/365.25*12

How bothered are you about the 31 and this will give a different
reading as all months are not the same length than the literal number
of months, but it is very close

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509270

You can use DATEDIF() for this: with today's date in A1 and 31/12/08 in
A2 the formula is

=DATEDIF(A1,A2,"M") +
DATEDIF(DATE(YEAR(A1),MONTH(A1)+DATEDIF(A1,A2,"M") ,DAY(A1)),A2,"D")/31



Frank wrote:
I need to calculate the number of months from today to 2008 Dec 31, and
put that in an Excel cell with equal sign, and fraction of a month is
divided by 31.

How do I do that?

PS: I am not looking for dedicated VBA script module.

Thank you.

I guess Excel takes care of the fact that months have a different nmber
of days.

So when you you subtract date1 from date2 and the receiving cell is
formatted as e.g. dd.mm.yy then the result would read something like
11.23.02 which means the difference is 11 days, 23 months and 2 years.

Hans

No, this is not correct. Try a few examples.


flummi wrote:
I guess Excel takes care of the fact that months have a different nmber
of days.

So when you you subtract date1 from date2 and the receiving cell is
formatted as e.g. dd.mm.yy then the result would read something like
11.23.02 which means the difference is 11 days, 23 months and 2 years.

Hans

No, this is not correct. Try a few examples.


flummi wrote:
I guess Excel takes care of the fact that months have a different nmber
of days.

So when you you subtract date1 from date2 and the receiving cell is
formatted as e.g. dd.mm.yy then the result would read something like
11.23.02 which means the difference is 11 days, 23 months and 2 years.

Hans

You are right, I should have tried it. :-(

How about this:

="="&DATEDIF(TODAY(),DATE(2008,12,31),"m")+ROUND(( DATEDIF(TODAY(),DATE(2008,12,31),"md")/31),2)

should give you something like =34.77 with the equal sign

HTH
JG

"Frank" wrote:

I need to calculate the number of months from today to 2008 Dec 31, and
put that in an Excel cell with equal sign, and fraction of a month is
divided by 31.

How do I do that?

PS: I am not looking for dedicated VBA script module.

Thank you.