MS Stand out Tips: Discover The Distinction Between Two Dates Using DATEDIF
This can be a little-known function in Stand out recently despite the fact that it’s been available in most versions since 95, this will make it recorded only within the Help file of 2000 but no further documentation from it in almost any other versions.
Nonetheless this function is mighty helpful for calculating an employees age, period of service or even the length or amount of financing.
This Stand out function really means DATED DIFFERENCE, ie it finds the main difference between two dates. The dates could be calculated in many variables, that’s year, month, day or hrs.
The best way to make use of this function or it’s syntax is the following
=DATEDIF (Date1, Date 2,Interval)
Where Read more…







