Is it possible to increase the amount of date range requests within a single formula?
Hi,
Is it possible to increase the amount of date range requests within a single formula? I'm currently trying to return a value for first half of year and then 2nd half but for multiple years? It appears to be working for the 2021 year but not for the others.
Here is what I currently have: but receive unparseable error when the date is past 2022.
=IF(AND([Date of Survey]@row >= DATE(2021, 1, 1), [Date of Survey]@row <= DATE(2021, 7, 1)), "H1 2021", IF(AND([Date of Survey]@row >= DATE(2021, 7, 2), [Date of Survey]@row <= DATE(2021, 12, 31)), "H2 2021", IF(AND([Date of Survey]@row >= DATE(2022, 1, 1), [Date of Survey]@row <= DATE(2022, 7, 1), "H1 2022", IF(AND([Date of Survey]@row >= DATE(2022, 7, 2), [Date of Survey]@row <= DATE(2022, 12, 31), "H2 2022", IF(AND([Date of Survey]@row >= DATE(2023, 1, 1), [Date of Survey]@row <= DATE(2023, 7, 1), "H1 2023", IF(AND([Date of Survey]@row >= DATE(2023, 7, 2), [Date of Survey]@row <= DATE(2023, 12, 31), "H2 2023"))))))))))
Thank you for any assistance.
Answers
-
=if(month([date of survey]@row) < 7,"H1 ","H2 ")+year([date of survey]@row
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!