Formula to Calculate Building Age from Opening Date

Maddy Menna

Hello All,

I'm trying to create a formula that will automatically calculate the age of a building based off the Opening Date. I have two columns "Opening Date" and "Building Age". In the Building Age column I've tried a few formulas but keep receiving various errors.

=TODAY-([Opening Date}@row)

One thing to point out is the Opening Date has a date profile and Building Age is text/number.

Any recommendations would be greatly appreciated!

Corey W.

slight syntax error, try:

=TODAY()-([Opening Date}@row)

Corey W.

slight syntax error, try:

=TODAY()-([Opening Date}@row)

Maddy Menna

Excellent! This worked for number of days. Is there a way to get it to reflect years?

Thanks so much for your help

Maddy Menna

Figured it out! Thanks so much for the assist.