Need Help with Annual Date Formula

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am trying to create a formula that references a date of birth field (Date), and acts as a countdown until that date occurs again next. For instance, if someone has a Date of Birth of 06-09-1983, I want to know how many days until 06-09 occurs again.
Photo of Shawn Petrunak

Shawn Petrunak

  • 122 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Make a formula duration field and use the following:

var number Age=(Year(Today())-Year([DOB])-1)
+If(Month(Today())=Month([DOB]) and Day(Today())>=Day([DOB]),1,0);

var date Birthday=AdjustYear([DOB], $Age+1);


You are basically finding the age, finding the next birthday, and then finding the difference (duration) between the birthday and today.

(Yes I'm getting old)