View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DarkNight DarkNight is offline
external usenet poster
 
Posts: 15
Default calculating months

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.