ContributionsMost RecentMost LikesSolutionsRe: Formula two fields two comparisonsIt worked! Thank you so much for your help. ------------------------------ Alexander Kouzmine ------------------------------ Formula two fields two comparisonsHello All, I've managed to get to this point Case(true, ToDays(Today()-[Class Start Date])<35, "In Training", ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised", ToDays(Today()-[Class Start Date])>=77, "Production", "Hasn't Started") The complete logic that I need is If [Program Assignment] = "Brokerage" then Case(true, ToDays(Today()-[Class Start Date])<35, "In Training", ToDays(Today()-[Class Start Date])>=35 and ToDays(Today()-[Class Start Date])<77, "Supervised", ToDays(Today()-[Class Start Date])>=77, "Production", "Hasn't Started") If[Program Assignment] = "Acquisition" then Case(true, ToDays(Today()-[Class Start Date])<35, "In Training", ToDays(Today()-[Class Start Date])>=35, "Production", "Hasn't Started") Is it something possible to achieve? Thank You ------------------------------ Alexander Kouzmine ------------------------------