Original Question: "I use Excel to store the names of clients, including their ages. Can Excel automatically calculate and update the age of a person?
System: Windows XP
An office colleague suggested "=DAYS360(J145,NOW())/360". The J145 cell will have the value "4-Apr-49". Although it works, Excel gives a pop-up window that says "formula results volatile".
Is this above fomula acceptable?
thanks"
Answer: "Hi,
Welcome to MrExcel!
Try,
=DATEDIF(J145,TODAY(),"Y")&" Years and "&DATEDIF(J145,TODAY(),"ym")&" Month(s)"
HTH"
=================================================
Another question: The formula works well. Now I have another related problem.
I also need to extract a range of ages of clients. For exampled, I need to extract those clients whose ages are from 40 years old to 50 years old. Is it easy to create a formula to extract ranges?
thanks
System: Windows XP
An office colleague suggested "=DAYS360(J145,NOW())/360". The J145 cell will have the value "4-Apr-49". Although it works, Excel gives a pop-up window that says "formula results volatile".
Is this above fomula acceptable?
thanks"
Answer: "Hi,
Welcome to MrExcel!
Try,
=DATEDIF(J145,TODAY(),"Y")&" Years and "&DATEDIF(J145,TODAY(),"ym")&" Month(s)"
HTH"
=================================================
Another question: The formula works well. Now I have another related problem.
I also need to extract a range of ages of clients. For exampled, I need to extract those clients whose ages are from 40 years old to 50 years old. Is it easy to create a formula to extract ranges?
thanks