Am more familiar with Access, but have created a function in XL07 as follows:

Public Function AgeIt()
Selection.NumberFormat = "0.00"
ActiveCell.FormulaR1C1 = "=(TODAY()-RC[-1])/365"
AgeIt = ActiveCell.FormulaR1C1
End Function

to calculate a person's age when the birthday is in the cell to the left.

When I select the function and insert it into a cell, I get =AgeIt() on the
formula bar, but #VALUE! in the cell.

What am I missing???

Thanks in advance for your help.