User Tools

Site Tools


datetime
  • =DATEDIF(E2, J2, “M”)
  • Code Description Explanation
  • “d” Days The number of days between Date1 and Date2.
  • “m” Months The number of complete months between Date1 and Date2.
  • “y” Years The number of complete years between Date1 and Date2.
  • “yd” Days excluding Years The number of days between Date1 and Date2, as if Date1 and Date2 were in the same year.
  • “ym” Months excluding Years The number of months between Date1 and Date2, as if Date1 and Date2 were in the same year.
  • “md” Days excluding Months & Yrs The number of days between Date1 and Date2, as if Date1 and Date2 were in the same
datetime.txt · Last modified: 2017/09/28 16:39 by zeppo