Thursday, May 5, 2022

CALCULATING THE DIFFERENCE BETWEEN TWO DATES

 WHAT IS THE FORMULA FOR CALCULATING THE DIFFERENCE BETWEEN TWO DATES

While it is easy to just click like in our example table below cell B2-A1 which automatically gives the difference in days, what if one needs the difference to be in Months or Years. Therefore, to calculate the difference between two dates with the foregoing in mind, see the applicable formula in the table below and take note of the unit measures in double quotes "D", "M", and "Y" in the formula that allows the difference to be in days, months and years.
Examples:


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Why Give?

  ic Give not because you have enough, not even because you expect a payback some day, and not even because you want to be celebrated by tho...