Multiple Date Ranges, If Then

This formula works. My question is - if I want to add date ranges for 2021, 2022, 2023, etc., what is the syntax to add the other date ranges onto the end of this formula?

=IF([Actual Finish]@row >= DATE(2020, 6, 30), [Actual Finish]@row <= DATE(2021, 7, 1), "2020")

Thank you!

Find more posts tagged with

Accepted answers

All comments

Devin Lee

You can try something like this.

=IF(MONTH([Actual Finish]@row) <= 6, YEAR([Actual Finish]@row), YEAR([Actual Finish]@row) + 1)

Sandra Unger

Hmmm Devin, I'm not sure that's what I'm looking for or maybe I just need to think about this a different way.

Perhaps I can describe it more clearly.

If the "Actual Finish" date is between July 1, 2020 and June 30, 2021, I want it to put "2021" in the column titled "Completion Fiscal Year".

If the "Actual Finish" date is between July 1, 2021 and June 30, 2022, I want it to put "2022" in the column.

I can get it to work for one date range (1 year) but I want to add more date ranges for subsequent Fiscal Years.

Sandra Unger

Devin, I see what you are suggesting now. That is so much simpler. Thank you!

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.