Formula to generate date 1 year from today?

I am trying to figure out a formula that will generate a date that is 1 year from today.

For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.

Find more posts tagged with

Formulas

Accepted answers

All comments

DKazatsky2

Hi @Haley Lavender,

I would suggest using a column that has the contract start date and use that static date to determine 1 year later. There is a TODAY() formula that can be used but it will continually change your value as "today" changes.

So, the Earliest Possible Termination Date column could use the following column formula.

=[Contract Start Date]@row + 365

Hope this helps,

Dave

Haley Lavender

Hi @DKazatsky2, thank you for your response! I am very interested in learning the TODAY() formula that will continually change value as "today" changes -- that's actually what I'm needing to accomplish in my sheet. Could you please share how you'd use that formula?

DKazatsky2

@Haley Lavender ,

All you need to do is use TODAY() in any formula. So to get the date in one year you would use =TODAY() + 365.

Best of luck,

Dave

austinbaker96

=DATE(YEAR(TODAY())+1, MONTH(TODAY()), DAY(TODAY()))

This way is a little more flexible, can do with months or days too but here you have format to do any.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.