| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of months between 2 periods?
Does anyone have any suggestions on how to determine the number of months
between 2 periods? the default day is always 1 for both periods. such as 1997-10-1 [A1] and 1996-10-1[A2] then return 12 in cell B1 Does anyone have any suggestions? Thank in advance for any suggestions? Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the number of months between 2 periods?
try:
=DATEDIF(A2,A1,"m") "Eric" wrote: Does anyone have any suggestions on how to determine the number of months between 2 periods? the default day is always 1 for both periods. such as 1997-10-1 [A1] and 1996-10-1[A2] then return 12 in cell B1 Does anyone have any suggestions? Thank in advance for any suggestions? Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the number of months between 2 periods?
Use DATEDIF()
=DATEDIF(A1,B1,"m") -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Eric" wrote in message ... Does anyone have any suggestions on how to determine the number of months between 2 periods? the default day is always 1 for both periods. such as 1997-10-1 [A1] and 1996-10-1[A2] then return 12 in cell B1 Does anyone have any suggestions? Thank in advance for any suggestions? Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the number of month between 2 periods? | Excel Discussion (Misc queries) | |||
| How to determine the number of month between 2 periods? | Excel Worksheet Functions | |||
| How to determine the number of workday between two periods? | Excel Worksheet Functions | |||
| How to determine the number of workday between two periods? | Excel Discussion (Misc queries) | |||
| Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
Linear Mode
