Formula to Calculate Building Age from Opening Date

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!

Find more posts tagged with

Accepted answers

Corey W.

slight syntax error, try:

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.