I have two fields which I an concerned with, A1 and A2. In A1 I have a fixed date, we'll say 1/1/11. In A2 I want it to calculate the time that has passed since that date. SO if today was 2/1/11 in A2 it would say 1mos. I am targeting years and months and I'm not really concerned with days. Is this possible? Thanks!

Perhaps

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It says Circular Reference Warning and the result of the cell is 0

Ooops , sorry
Replace A2 with TODAY() in the above formula tHat should do the trick

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Lights,

I'm not a big fan of adding text to the formula result because it stops you using that answer in another formula. I would possibly use the following formula:

=(MONTH(TODAY())+YEAR(TODAY())*12)-(MONTH(A1)+YEAR(A1)*12)

This will give you an integer (whole number) as a result. After that I would use a custom format to add the text that you want into the same cell as the formula.



After you enter the formula:

1. go into format cells (Ctrl + 1)
2. select the number tab
3. choose custom (bottom of the list)
4. in the type box, type: 0" mos"
5. click OK

This will display at least 1 number and add " mos" after it and it won't break any formulas.

Caholmes

your formula does not take the day into account but only months, therefore creating a result which might not be what the OP needs. Test it for March 31st and you will see that it returns 1 month, although it's less than one month. ( 19 days today)

If one is only concerned about the number of months gives the number of entire months between two dates

But then again, as is common with dates, the OP did not specify what he wants exactly

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post