The correct thing is that:

on column F5 it put the formula: =DATA.DIFF(E5; TODAY(); “YD”);

Array formulas return multiple values automatically and do not need to be copied down.

Use datedif(). Put this formula in cell F2:

=arrayformula( 
  if(len(E2:E), datedif(E2:E, today(), "YD"), iferror(ø)) 
)

See datedif().

The goal is to calculates the difference in days from today to the birthday date in E3, E4, etc., disregarding the year dates in the cells, and assume that they’re for the current year (e.g., 2024).

You may also try this in F2:

=ARRAYFORMULA(IF(E2:E="", "", TEXT(TODAY(), "MM/DD")-TEXT(E2:E, "MM/DD")))

I’ve noticed that DATEDIF only calculates leap years if the year provided in E2:E is one, so for 02/06/1977, since 2024‘s a leap year, it returns 311 instead of 312. This is a minor issue of a day unless you need the output to be specific.

Note: Similar to @doubleunary’s answer, you don’t need to drag the formula down since the IF function within the ARRAYFORMULA checks if there’s a date in Column E, ensuring that it only calculates the difference for valid birthday dates.

OUTPUT

REFERENCE

• TEXT
• MINUS function