Hi,
Not sure if you'll have any more success than you're having with Pete's
suggestions, but here goes:
Select all cells in the range U2:IU197. Make sure you start the selection in
cell U2. When all cells are selected, U2 should be the only one that looks
different.
With all that selected, open the CF window, select formula is, and enter:
=U$1=TODAY()-365
Select the CF's you want.
OK.

I've tested this here, so it should work...

Regards - Dave.