Hey Mark, I appreciate you responding to my post. Essentially I have to create a manual report in excel for a wide range of companies on a quarterly basis. The quarterly months for each unique company is derived from the [static date AKA effective contract date]. These static dates are all in the past, some as far back as 2020. The static dates can be any given month, which is where the complication arises.I would like this formula to calculate and display when the next quarterly report is due based on the [static date AKA effective contract date]. However, I don't want it to display a date that is before the [Date Created AKA QuickBases standard field that is automatically applied to a table].
Thus, in response to your question, if I am understanding correctly, I don't believe "date created plus 1 month, else blank" would work in this scenario. The displayed date will vary based on the [static date] and [date created]. Does that make sense? It is difficult for me to articulate, but I'll do my best.So if report 1 has a [static date AKA effective date] of 2/1/2022, and the [date created AKA date report 1 is added into quickbase table] is 8/1/2022, I want quickbase to display the date of 8/1/22. (not to insult intelligence, just to fully explain and get on the same page --->) If the [static date AKA effective date] is 2/1/2022, I would need to write a report quarterly on dates: 5/1/22, 8/1/22, 11/1/22, and 2/1/23. Thus, why I need to include the [date created] is so that the formula identifies the first one of those quarterly dates that is equal to or greater than [date created] and then display it.