LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating months pkeegs Excel Discussion (Misc queries) 5 May 12th 06 03:59 AM
What is the formula for calculating the number of months passed? Teri Excel Worksheet Functions 5 March 9th 06 02:05 AM
Calculating an Activities During Periods Of Natural Months and/or Dates Rayco Excel Worksheet Functions 1 October 10th 05 01:30 PM
Calculating Dates in Terms of Months Jessica Excel Worksheet Functions 4 September 20th 05 06:35 PM
calculating number of months from today JNW Excel Worksheet Functions 5 September 15th 05 10:01 PM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"