Backdate into Last Year

Smartsheet User 99

Trying to backdate 6 months or 180 days from a specified date.

I'm able to go back 6 months without any issues, but I want to return that date for the 1st day of the month.

=DATE(YEAR([1st day]@row), MONTH([1st day]@row), 1) - 180

If it backdates into last year, it doesn't go to last year and instead changes it to the current year.

=DATE(YEAR([1st day]@row), MONTH([1st day]@row-180), 1)

I'm pretty sure I'm missing something simple, but can't figure it out. Please help. Thank You.

Find more posts tagged with

Accepted answers

Paul Newcome

Also subtract 180 from the date in the YEAR function.

All comments

Paul Newcome

Also subtract 180 from the date in the YEAR function.

Smartsheet User 99

thank you so much. Such a simple solution.

Paul Newcome

Happy to help. 👍️

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.