Rolling Month Count

[CNI]

Hi,
I am fairly new to excell so forgive me if my question has a simple answer. I am using Office 2007. I use a spread sheet to keep track of alot of different data. My problem is I keep track of how long I've been living at my current residence. For example I moved in on May 6, 2005 and every month i have to manually open the spread sheet on that specific date (May 6) and roll the month count up one more. Is there a way or a setting i can change so it automatically does this for me? Sometimes i forget and then i have to count back from the start.
If there is anyone that knows how to do this i know your that person. Looking forward to your reply.

 

[mvptomlinson]

You could use a formula like this:

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days"

This compares the date in A1 to today, and returns a value in "## years, ## months, ## days" format.