Hi all. new here, have a quick question for a spreadsheet I'm working on for work.

I have a checklist spread sheet that is meant to have the user put in dates. However, to save them time, at the bottom of each collum I'm adding a place for them to say "Yes" or "No" if all the things were handed in at once. As well, leaving a cell below that for them to enter the date that they were all handed in at once.

What I need is a way to then make all the cells in the collum above it to become that same date. HOWEVER, I need to not have a formula in those cells so they can easily be typed in, just in case things aren't all done at one time.

Thanks in advance