calculating months

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DarkNight - 24 Jul 2006 20:53 GMT

hello peeps i'm trying to calculate the number of months from a list of
increasing dates,
b3= 21-Jan-06
b4= 03-Feb-06
and so on
b16= 14-Jul-06
b17= and onwards ar blank
b25= DISPLAY No. MONTHS
i'll be adding more dates in cells b17 to b24 at a later date so would like
it to allow for this to happen
i enter the date as 14/8/06 and it gets displayed as 14-Jul-06 if that helps ?

i've tryed =datevalue(b16)-datevalue(b3) and get this ##############
Thanks inadvance.

Reply to this Message

Sandy Mann - 24 Jul 2006 21:25 GMT

Hi DarkNight,

Use the DATEDIF() function:

=DATEDIF(B3,B16,"m")

DATEDIF() is only explaind in Help in XL 2000 I believe, (i'm not that up to
date having onlyXL97), but Chip Pearson has a good explanation at:

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

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> hello peeps i'm trying to calculate the number of months from a list of
> increasing dates,
[quoted text clipped - 12 lines]
> i've tryed =datevalue(b16)-datevalue(b3) and get this ##############
> Thanks inadvance.

Reply to this Message

DarkNight - 24 Jul 2006 21:59 GMT

Thanks Sandy Mann yer a star.. yet again.

> Hi DarkNight,
>
[quoted text clipped - 22 lines]
> > i've tryed =datevalue(b16)-datevalue(b3) and get this ##############
> > Thanks inadvance.

Reply to this Message

Sandy Mann - 24 Jul 2006 22:33 GMT

You're very welcome

Signature

Regards,

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Thanks Sandy Mann yer a star.. yet again.
>
[quoted text clipped - 25 lines]
>> > i've tryed =datevalue(b16)-datevalue(b3) and get this ##############
>> > Thanks inadvance.

Reply to this Message

Rate this thread: