Formula to calucate # of months based on a speificed date entered
 

How can I set up a formula to determine # of months left for the year based
on the €œdate€� user entered?

For an example:
A user enter a date on cell A1 (04/05/05) then on cell A2 will display the #
of months left for the year. For this case, it will be €œ8€�.

--
Thanks,
David

Hi
=12-MONTH(A1)+1

--
Regards
Frank Kabel
Frankfurt, Germany
"David" schrieb im Newsbeitrag
...
How can I set up a formula to determine # of months left for the year
based
on the "date" user entered?

For an example:
A user enter a date on cell A1 (04/05/05) then on cell A2 will display the
#
of months left for the year. For this case, it will be "8".

--
Thanks,
David

One way

=DATEDIF(A2,DATE(YEAR(A2),12,31),"m")

Regards,

Peo Sjoblom

"David" wrote:

How can I set up a formula to determine # of months left for the year based
on the €œdate€� user entered?

For an example:
A user enter a date on cell A1 (04/05/05) then on cell A2 will display the #
of months left for the year. For this case, it will be €œ8€�.

--
Thanks,
David

One way:

=3DDATEDIF(A1,DATE(YEAR(A1),12,31),"m")

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I set up a formula to determine # of months left=20
for the year based=20
on the =E2?odate=E2?=9D user entered?

For an example:
A user enter a date on cell A1 (04/05/05) then on cell=20
A2 will display the #=20
of months left for the year. For this case, it will be=20
=E2?o8=E2?=9D.

--=20
Thanks,
David
.

Thank You!!!

"David" wrote:

How can I set up a formula to determine # of months left for the year based
on the €œdate€� user entered?

For an example:
A user enter a date on cell A1 (04/05/05) then on cell A2 will display the #
of months left for the year. For this case, it will be €œ8€�.

--
Thanks,
David