Marketing, Analytics, Marketing Analytics, Data Analytics, Digital Marketing.
11.28 days ago the highest value of 3. Those who placed an order from 11.28 to 14.28 days ago are assigned a value of 2. The rest, who bought more than 14.28 days ago, we assign a value of 1. All this can be automatically calculated with the formula =IF(B2<11.28; 3; IF(B2 <14.28; 2, 1)). Step 4: