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.

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
--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


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

Thanks Sandy Mann yer a star.. yet again.

"Sandy Mann" wrote:

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
--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


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

You're very welcome

--
Regards,


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"DarkNight" wrote in message
...
Thanks Sandy Mann yer a star.. yet again.

"Sandy Mann" wrote:

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
--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


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