Counting years/months instead of days.
I’ve got a date field “start” and a number field “years”.
The calculation result is a date and the field should be (“start” + “years”) - 1 day
if start is 1/1/2010 and years is 9, then the calculation should be 31/12/2018
I’m trying to make it work for months (other field) and years, but so far it only works if it is in days.
If I start 1/1/2010 + 9 years - 1 day the calculation is 9/01/2010
How do I tell it is a month or year?
Any help welcome.