DAYS Funktion in Formula Column

[Honor]

Hi there,

When I using the DAYS function, I sometimes get red exclamation marks !! Calendar objects can be calculated without problems, but monday cannot calculate the combination of a calendar object and a formula object.
Dont understand why ? How can I calculate the difference between a calendar object and a formula object?

DAYS({ILC},{Heute})

The {ILC} Field is a date calculated via a formula that is always given.

The {Heute} field is a calendar object that is also selected.

[JCorrell (Jim - The Monday Man)]

@Honor

What do you mean by “calendar object”?

[JCorrell (Jim - The Monday Man)]

@Honor

… regardless, it looks like the problem is that the function is not handling the “Okt.” properly.

Can you share the formula for that column?

[Honor]

Hi JCorrell,

By calendar object I mean the Date column, where you can select the date from the calendar.

Thank you for help !

[JCorrell (Jim - The Monday Man)]

@Honor

Can you share the formula for the ILC 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 !