Hi,
I use Xlookup to get the dates for my details tab. However, I need to refine the formula to get only today and any future dates, without getting old dates or even the dates that is formatted as 1/0/1900. Below is my sample data along with the formula that I'm using. Is there any suggestion to refine my formula to get the desired results?
Thanks!
I use Xlookup to get the dates for my details tab. However, I need to refine the formula to get only today and any future dates, without getting old dates or even the dates that is formatted as 1/0/1900. Below is my sample data along with the formula that I'm using. Is there any suggestion to refine my formula to get the desired results?
Thanks!
Xlookup Help with dates criteria.xlsx | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | Current Result | Desired Results | IDs | Dates | |||||||||||||
2 | IDs | Name | Dates | IDs | Name | Dates | AAA | ||||||||||
3 | AAA | John | 10/3/2024 | AAA | John | 10/3/2024 | BBB | 3/3/2024 | |||||||||
4 | BBB | Will | 9/3/2024 | BBB | Will | 9/3/2024 | CCC | 9/7/2024 | |||||||||
5 | CCC | Abbey | 9/7/2024 | CCC | Abbey | 9/7/2024 | DDD | ######## | |||||||||
6 | DDD | Don | 11/4/2021 | HHH | Leo | 5/1/2024 | EEE | ||||||||||
7 | EEE | Louise | 1/0/1900 | NNN | Leon | 3/8/2024 | FFF | ||||||||||
8 | FFF | Sue | 1/0/1900 | GGG | |||||||||||||
9 | GGG | Ron | 1/0/1900 | HHH | 5/1/2024 | ||||||||||||
10 | HHH | Leo | 5/1/2024 | KKK | |||||||||||||
11 | KKK | Frank | 1/0/1900 | OOO | |||||||||||||
12 | OOO | Ronaldo | 1/0/1900 | NNN | 3/8/2024 | ||||||||||||
13 | NNN | Leon | 3/8/2024 | BBB | 9/3/2024 | ||||||||||||
14 | ZZZ | Shondha | AAA | ######## | |||||||||||||
15 | LLL | Mona | 1/0/1900 | LLL | |||||||||||||
16 | |||||||||||||||||
17 | |||||||||||||||||
18 | |||||||||||||||||
19 | |||||||||||||||||
20 | |||||||||||||||||
Details |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3:C15 | C3 | =XLOOKUP(A3,$L:$L,$M:$M,"",,-1) |