Creating a formula to calculate age...

I need to create a formula to calculate age based on a cell that has a persons date of birth and I guess another cell that has the current date formulated into it. Any help would be apprecitiated....

Thanks

=ROUNDDOWN(((TODAY()-Ax)/365),0)


Where Ax = the cell with the DOB in it.
May be an easier way of doing it, but that works.

Originally Posted by homeuser

I need to create a formula to calculate age based on a cell that has a persons date of birth and I guess another cell that has the current date formulated into it. Any help would be apprecitiated....

Thanks

Hi homeuser,

Take a look at this link and it will tell you how to go about it

http://www.exceltip.com/exceltips.ph...nt_page&ID=634

oldchippy

Originally Posted by oldchippy

Hi homeuser,

Take a look at this link and it will tell you how to go about it

http://www.exceltip.com/exceltips.ph...nt_page&ID=634

oldchippy

Works [= you should conditional format as well to highlight if its someones birthday