DAYS Funktion in Formula Column

[Honor]

Hi JCorell, unfortunately I no longer have the previous code

This topic can be closed. Maybe you can help me with this one:

Calculate with month in formula column

Hello, I would like to calculate an end date for a contract, but I always deviate by a few days. I use the following formula calculation: SWITCH({CoP},36,1095,12,365,6,183,3,92,2,61,1,31,0)) The CoP variable is given in months. For example: 3-year contract has a CoP of 36 months aka 3*12 months =1095 days 1 year contract is a CoP of 12 months aka 365 days 1/2 year contract a CoP of 6 months aka 183 days and so on. In order for me to calculate a contract end date, I proceed as follows: I …

Thank you !