TotalDays() and other TOTAL formulas

Over the past week I think I’ve seen 3 or 4 people ask for a way to tell how many days have passed between two dates; with the addition of the formulas TOTALHOURS(), TOTALMINUTES(), etc. - perhaps a TOTALDAYS() is warranted?

Why not also include:

  • TOTALDAYS()
  • TOTALWEEKS()
  • TOTALMONTHS()
  • TOTALYEARS()

Thanks for considering! :nerd_face:

I m always struggling with date, time type of data fields to yield the duration with even simple math, add, subtract. Native function should ease our pains, thanks for raising.

1 Like