Hi, Thanks for your assistance and time.
This formula works nice for my needs, of repeating a value.
=if(mod(column()-1,3)=0,$a$4,0) it displays my value every 3rd column, in row 4.
I have 365 columns with date in row 3, for each day of the year. E3 has Jan 1, 2018.
i want to put a date in...