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!
Answers
-
You can try something like this.
=IF(MONTH([Actual Finish]@row) <= 6, YEAR([Actual Finish]@row), YEAR([Actual Finish]@row) + 1)
-
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.
-
Devin, I see what you are suggesting now. That is so much simpler. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!