| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help calculating months
I have 1 colum of dates, in another i would like the number of months between
today and that date, either positve or negitive. However "=month(x)-month(y)" doesnt recongnize a difference in years. For example 4/17/07 - 7/10/06 returns -3 instead of +9. My dates vary from over a year ago to over a year from now. Does anyone know of a possible solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
