Need Formula for calulating age from birthdate from current date. I have used
=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
of 2005. I need formula to calulate age as of today's date or by current
month. I want to show the age in the cell next to the birthdate without
using a date reference from another cell.

Thanks.