| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help calculating months
=(YEAR(NOW())-YEAR(A2))*12+(MONTH(NOW())-MONTH(A2))
"Baldrick" skrev: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help calculating months
=datedif(start_date,end_date,"m")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Baldrick" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help calculating months
Thanks, it working like a champ.
"excelent" wrote: =(YEAR(NOW())-YEAR(A2))*12+(MONTH(NOW())-MONTH(A2)) "Baldrick" skrev: 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? |
| Reply |
| 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 | |||
Linear Mode
