I have a bit of dilemna and was hoping it could be solved by a workflow or custom formula( the ones I've tried seem to not work). I'm trying to add a duration field ( In months example: 6 months) to a start date field which is in date format( 2/1/2024). IN the calculated property i created I used this formula: [properties.expected_project_start_date]+ ([properties.duration]/12*365) = End date(In date format)
however I just get the project start date and not getting the desired date. Any help would be appreciated if this is even possible