Is it possible to get open office calculate age given date of birth?

I'm trying to get it to link two tables to calculate age; so the effect is that the date of birth is written into one table, and the age is shown in another. Is there a way to do this?|||In my example, the first table, titled Sheet1 (the default name in Open Office) will have the the person's birth date entered in the A1 cell. What you want is this:





=YEARS(Sheet1.A1;NOW();1)





This calculates the amount of years between the first variable �?the birth date �?and what is the current time on your computer. 1 is something else for display reasons I think. Replace Sheet1 with the table's name and A1 with the cell on that page where you input the birthday and you are set!|||join the open office user group (free) then you will be able to ask all the questions there





for a list of user groups click on the link below