-
Re: Column Formula for a future date, 3 months before annual start date
@Humashankar It's probably not that simple. [Start Date] is for a contract date. The [End Date] is the last date of the approved term. Term can be for one year, or up to 5 years. Regardless if term i…1 · -
Column Formula for a future date, 3 months before annual start date
Hello everyone, I have a column formula that creates a date in the future based on [Start Date] while simultaneously avoiding child rows: =IF(AND(Hierarchy@row = 0), IF(MONTH([Start Date]@row) >3,…1 ·