Formula to compare dates and then replace numeric answers with text
Hope I can get some help with this formula --- Datecomp(${Accounts.Trial close date},Now())/1440/7 --- The results of this formula in my case will be either 1, 2, 3, or 4. I need the formula to translate the answers as follows. 1 = 1 Week, 2 = 2 Weeks, 3 = 4 Weeks, 4 = 4 Weeks. Within the same formula.
Anyone know the answer to this one?