ah2024_2024
New Member
- Joined
- Jun 18, 2024
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
First off, I'm not able to download anything on my work computer so I will only be able to utilize a screenshot.
Column AS (Deal in 1st 2 Weeks) has this formula: =IF(AND($AP2,">=2/1/2025",$D2<=$AR2,$AQ2=2,$O2,"<>*Flat rate"),"YES","NO") and all the piece but the first piece that references >=2/1/2025 works.
But notice that the first line of data that START DATE (column AP) IS greater than or equal to the date of 2/1/2025 and AS (where my formula is) correctly displays a YES.
But the next line of data that has a start date BEFORE 2/1/2025 is also displaying a YES in AS but should be giving me a NO since the start date IS NOT greater than or = 2/1/2025
Where am I going wrong with the formula? I've tried to change it to be AP>=2/1/2025 and gives the same result of a yes.
Basically, the formula is should be saying if this person started 2/1/2025 forward, then do the rest of what I need/am looking for.
Column AS (Deal in 1st 2 Weeks) has this formula: =IF(AND($AP2,">=2/1/2025",$D2<=$AR2,$AQ2=2,$O2,"<>*Flat rate"),"YES","NO") and all the piece but the first piece that references >=2/1/2025 works.
But notice that the first line of data that START DATE (column AP) IS greater than or equal to the date of 2/1/2025 and AS (where my formula is) correctly displays a YES.
But the next line of data that has a start date BEFORE 2/1/2025 is also displaying a YES in AS but should be giving me a NO since the start date IS NOT greater than or = 2/1/2025
Where am I going wrong with the formula? I've tried to change it to be AP>=2/1/2025 and gives the same result of a yes.
Basically, the formula is should be saying if this person started 2/1/2025 forward, then do the rest of what I need/am looking for.