Looking for a formula to extract value from exactly past 1 year

I need a formula to return value only if the date is opened from exactly last year. If my current system date is 3/24/23, i need value to be returned exactly from 3/24/22 to 3/24/23.
The formula what i have right now is pulling data from 3/1/22 to 3/24/23. But i need data from 3/24/22 to 3/24/23.
Can someone please help on this.
=IF(ISDATE([Date Opened]@row), IF(AND([Date Opened]@row >= DATE(YEAR(TODAY()) - 1, MONTH(TODAY()), 1), [Date Opened]@row <= TODAY()), "NA", Level@row))
@Paul Newcome : Can you help me on this please? i need help with this formula.
Answers
-
Try somethign like this:
=IF(ISDATE([Date Opened]@row), IF(AND([Date Opened]@row >= DATE(YEAR(TODAY()) - 1, MONTH(TODAY()), DAY(TODAY())), [Date Opened]@row <= TODAY()), "NA", Level@row))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!