I am looking to return a calculated value based on a column named Date, I have three options I need to consider: If Date is between today and next 6 days return A If Date is more than 6 days ahead but in this month return B If Date is this after the 10th day month and before the end of the following month return B else return C
Any suggestions on how to achieve this?