Google Sheets arrayfomula is not working in other column but working in another

Question

Currently, I am working on a google sheet, and I put two array formulas in the sheet. One is working, and one is not. Please, anyone, help?

This formula, which I used to print the "Month" name in the column, works. This formula is working

This formula where I want to print the days passed from the date Column "C" is not working; it is only working for the AA2 column and printing the same value to all other AA columns. This is not working

question from:https://stackoverflow.com/questions/65914594/google-sheets-arrayfomula-is-not-working-in-other-column-but-working-in-another

Answer 1

In cell AA1 try

=ArrayFormula({"Days passed"; IF(LEN(C2:C), TODAY() -C2:C,)})

and see if that works?