Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • The Community Treasure Chest
  • Complex Math and Date Formulae

Computing the Number of Years and Months

Written by Service Desk

Updated at October 12th, 2022

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Introductions to our Software
  • The Learning Curve, Three Training Courses
    The Readers' Digest Condensed Version In the Beginning, The Lesson Plan #1 The Lesson Plan, The Lesson Plan #2 The Learning Curve Basics, #1 The Learning Curve Intermediate Level, #2 The Learning Curve Advanced Level, #3
  • Installations and Emergencies!
    Installation Instructions Network, Unusual, Troubled, or Manual Installations Emergencies — What to do when things turn hot
  • Videos: Deep Dives on Specific Features
    Form Sets Doxserá DB and Its External Sources
  • Doxserá DB Library
    Doxserá DB, What can it do? Doxserá DB, How does it work? Doxserá DB, In-depth features and functions
  • Resource Library
    Guides and Manuals Video demonstrations of the Lessons in the Expert Guide Organizing Files, Folders, Documents, Templates… and Your Life Converting WordPerfect to Word
  • The Community Treasure Chest
    Truly Complex Roles Complex Math and Date Formulae Tidbits That Can Improve Your Experience Company Organization and Formation Oklahoma Dissolution Form Examples Sources: Master Lists, Spreadsheets, and other data sources Little Tools
  • Aurora
  • Word Warriors®
    About Micrsoft Word Tips & Tricks
  • News and Updates
    Staying up to date Current Versions of Our Software Updates for Doxserá and TheFormTool Archives
  • More
    All Things Mac, Linux, Tablets, and Other Items Miscellaneous Feature Requests
+ More

There are a zillion needs to compute years and months: How many years and months are left in the (lease, loan, contract)? How long have you been a resident? How old is your dog?

While the Age function in our software does a terrific job on the "years" portion of the problem — even taking into account leap years, short months, exact date of birth — the "months" portion can be a bit more complex, starting with the definition of "month." While February and March are obviously two different months, when does the period between them count as a "month?" Is 2/28 to 3/1 a month? Under some circumstances, by some definitions, yes. If that is the case, the software's builtin "Month" function will do just fine; it counts each change in the name of the monthly period as a month. Feb-Mar is one month. Feb-June is four, etc. So to solve the whole number of years/ number of months problem is as simple as determining the start and end dates, possibly include the "Now" function as one or the other, then building a Field using the Math screens to pull up YEARS and MONTHS.

It's a bit more complex if "month" is defined as the period starting on a particular date of a month and ending on the same or some later date in some subsequent month. For example, 2/12 to 3/12 would be one month, but 2/13 to 3/12 would not.

The attached form shows the Derived Answers, definitions of date, Math functions, and Conditions necessary to compute all that while making it easy-peasy simple for the User. You can copy the Rows, Fields and Conditions necessary to match your needs and paste them into your form, using your own language for the Questions.

Remember to use the Show/Hide command to hide the Derived Answers.

Click to download an operating form that performs these calculations.

tags: year, month, term, length, time, calendar, lease, loan, date

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • A complex but fun Calendar Offset solution to a difficult and high-error statutory document issue
  • How to Compute a Monthly Lease Payment
  • Naming the Months Between Two Dates
  • Reduce Social Security Account Number (SSAN) to Final Four Digits
Recent posts
  • Multi-Party, Multi-Role Decisioning
  • The Fastest Training
  • Inflation is Going to Grow, a Lot
  • The lowest-hanging fruit
  • Technical tidbits from TheFormTool, LLC
  • Improving Your Firm’s Support Structure
  • The Knowledge Base
Request for information

Submit

Recent Tweets
  • While TheFormTool remains amazingly easy to use, it's fully capable of managing truly complex document assembly nee… https://t.co/DHPPwcNv1M 6 days ago
  • It was in January 2021, that we first forecast massive inflation was coming our way. Whether it is called “quantita… https://t.co/Ab3MV1SLQz 26 days ago
  • Low-hanging fruit: the most often used features of document assembly systems. Automatically: perfect pronouns and p… https://t.co/A5rg6zRSd8 200 days ago
Copyright ©2012-2022 TheFormTool, LLC. All rights reserved.

Knowledge Base Software powered by Helpjuice

  • Home
  • Contact Us
  • Privacy
  • TheFormTool User License
  • Site Map
——— bottom-nav
Expand