Formula for # of years since inception
I am trying to get # of years & months since inception from today's date. //ToDays([Inception Date]- Today()) / 365.25 I end up with a -negative #. ------------------------------ [Deb] ...
Forum Discussion
You are getting a negative number because the inception date is a smaller value than the current date. Change your formula to today - inception date
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
You could also make the formula a little cleaner:
Year(Today()) - Year(inception Date)
------------------------------
Paul Peterson
------------------------------
Year(Today()) - Year(inception Date)
------------------------------
Paul Peterson
------------------------------