eramirez148
Board Regular
- Joined
- Aug 17, 2022
- Messages
- 54
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- MacOS
Cell D1 will automatically update with today's date. I need a formula in column D that will take into account column A, B, and C and consider cell D1 to populate active or inactive based on the current date.
a | b | c | d | |
1 | May | June | July | 5/24/2023 |
2 | Active | Inactive | ||
3 | Active | Active | ||
4 | Unactive | |||
5 | Active | Unactive | ||
6 | Active | Active | ||
7 | Active | Inactive | ||
8 | Inactive |