Help Needed with DATETIME_DIFF Formula to Calculate Upcoming Birthdays in Stackby

Ask the Community Formulas
#1

I’m trying to create a formula to identify upcoming birthdays within the next two months. I want the formula to return “Soon” if the birthday is within this time frame

#2

To create a formula that identifies upcoming birthdays within the next two months and returns “Soon” if the birthday is within this time frame, you can use the following formula

IF(DATET_DIFF(TODAY(), {Birthday}, "months")<=2, "Soon")

  • TODAY(): This function returns the current date.
  • {Birthday}: This is the field containing the birthday date.
  • DATE_DIFF({Birthday}, TODAY(), "months"): This calculates the difference in months between the birthday and today’s date.
  • <= 2: This checks if the birthday is within the next two months.
  • IF(..., "Soon"): This returns “Soon” if the condition is met.