In cell AA2 I am using the formula =IF(A2:Z2<>A2:Z2, “”, TODAY())

This formyla is supposed to update AA2 with today’s date if any edits are made to cells A2 through Z2. This works, but, it also populates the next 25 cells in the row with the equation. The formula is not a dark black color in the top box as it normally would be but instead a subdued gray. Only when the formula is activated does this occur, so if the row has no entries there is no date stamp or extra cells with a date stamp.

Is there a way to limit this formula to only being used and displayed in cell AA2?

Many thanks for your assistance with this!

~ Leo Frost