Skip to main content
Question

Formula for # of years since inception

  • June 2, 2020
  • 0 replies
  • 45 views
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]
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Can you an example of a date and what the result should look like.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
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
------------------------------
Terms & ConditionsAccessibility statement