Hello Folks,
I am trying to use the below formula, but Monday is not recognizing the EDATE function. Any ideas?
IF(AND(
FORMAT_DATE(DATE(2024,2,DAY({StartDate})),“YYYY-MM-DD”)>={StartDate},
FORMAT_DATE(DATE(2024,2,DAY({StartDate})),“YYYY-MM-DD”)
<FORMAT_DATE(EDATE({StartDate},{DurationInMonths},“YYYY-MM-DD”))
),{DealAmount}/{DurationInMonths},“”)