How to find a new date based upon a date column?

Platform discussions Special workflows & use cases
, ,
1

Hello, I am trying to figure out how to add months and/or years from a specific start date using formula column, without success.

Example:
Start date (DDMMYYY): 05.01.2024
Rights period from start date: 3 years and 6 months
What end date? (The correct date should be 04.07.2027)

The formula in Excel to calculate this is:
=DATE(YEAR(X110)+3;MONTH(X110)+6;DAY(X110)-1)

Does anyone know how to solve this in Monday?

2

Hi Anita,

You can use the ADD_DAYS function. ie you would have to assume that a year is 365 days and a month 30 or 31.

The other possibility is to use the EDATE function which is documented at The monday Hidden Functions – The Monday Man. It allows you to add months.

Want to get rid of the formula column and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com