Hello all,

I have done some searching and have been unable to find a solution so far.

I have a spreadsheet containing names, dates of birth, age, etc. I have figured out the formula to generate the age of the person from the date of birth I provide through some basic searching; however, in this spreadsheet there are fields that are going to be marked "N/A" because there is not always a date of birth provided or necessary for what I am logging. Is there any way to write the formula so it can ignore this? What I'm finding is that the formula stops at the cell I enter "N/A" into and I would have to re-enter the formula each time.

Here is the formula I am currently using:

fx=INT((TODAY()-A1)/365.25)

I'm also trying to program the spreadsheet to have the formula built-in. The spreadsheet is used every day of the year so I would like to have it pre-programmed so I can simply type the date of birth and it automatically generates the date regardless of which day of data I have clicked on. Right now I don't feel like that's possible because as soon as "N/A" is entered into the Age field, the formula stops generating for the cells after that. I feel I can find this through searching, so if you know how to do this and want to post it, I'd appreciate it, but I believe I can solve this second part myself.

Any help or direction is appreciated.

Thanks,

Tim