Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating months | Excel Discussion (Misc queries) | |||
What is the formula for calculating the number of months passed? | Excel Worksheet Functions | |||
Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
calculating number of months from today | Excel Worksheet Functions |