eramirez148
Board Regular
- Joined
- Aug 17, 2022
- Messages
- 54
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- MacOS
How can I add the following results in the "Status' column. I want it to read today's date and if today's date falls withing the range of "VP start" and VPer.End" then the results should be "Active" if todays date is outside the range then "Not Active"
Todays Date | 10/30/2023 | |
VP Start | VPer.End | Status |
11/1/2021 | 10/22/2023 | Not Active |
3/31/2023 | 11/24/2023 | Active |
3/31/2023 | 11/24/2023 | Active |
3/24/2023 | 11/24/2023 | Active |
3/24/2023 | 11/24/2023 | Active |
11/1/2023 | 12/1/2023 | Not Active |