Is there a way to not type DATE formula manually?

Christina09 ✭✭✭✭✭✭

I have a sheet with the date as the column name and have a cross-sheet formula with SUMIFS and DATE. Is there a way I don't have to type the date manually? Unfortunately, I have over 100 columns that I need to modify the date to match the column 😥

You'll be a lifesaver if there is a way!

Thank you in advance!!🙇‍♀️


Best Answer