calculating months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Thanks Sandy Mann yer a star.. yet again.

Sandy Mann said:
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
Click to expand...
 
You're very welcome

--
Regards,


Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top