Hi everyone
In a table I have to insert different courses that have a specific duration. The column is called “TRaining Description” and refers to the “Cours Table” table where each course has a valid duration. the value before was in Months, now it has been transformed into Years. Example 24 months = 2 Years. In practice with this formula
EOMONTH([Training Date], ([Validity months]-1)) + DAY([Training Date])When I entered the course date automatically in the “Expiring date” column it gave me the date when the course would expire. How can I adapt the formula?
Thanks, if you need more info I’m available 
Not sure I understood correctly, but if you are trying to get the expiring date based on years of validity, you can use:
[Training Date]+([Validity]*365)
1 Like
Hi, thank you, the formula works great!!!