-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,051
Welcome to the MrExcel forum!
It's hard to come up with a formula referencing B2 since you didn't show us the formula there. It apparently returns a text value. But if you're looking to see if the date in A2 is more than a year old, try this:
It's hard to come up with a formula referencing B2 since you didn't show us the formula there. It apparently returns a text value. But if you're looking to see if the date in A2 is more than a year old, try this:
| Book2 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Hired Date | Years | Yes/No? | ||
| 2 | 9/9/2021 | 0 Years, 1 Months, 17 Days | No | ||
Sheet3 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2 | C2 | =IF(A2<=EDATE(TODAY(),-12),"Yes","No") |
Upvote
0
Solution
