VBA or a formula to auto populate

[jme1013]

I have a spreadsheet that I track my time in. I have one column that is for comments. Based on certain text I put in the comments, that row will change formatting using conditional formatting.

My Problem: I have a few reoccurring items that I put in the comments, such as "Pay Day". I'd like to be able to type in "Pay Day" one time, the first pay day of the year, and for it to auto populate the "Pay Day" in the subsequent cells (every 2 weeks).

My Question: Is this something that needs to be done with VBA or can it be done with a formula? Keeping in mind, I need to be able to type in these cells for other occasions that are not reoccurring.

I've attached my file, it is protected but with no password. I've already manually entered "Pay Day" in all the appropriate rows.

[than_gold]

There are 4 sheets, where do you want to have this effect? in which cells?

[jme1013]

They are all the same. Just for different schedules. Column U:X is where I type my comments and where I would need my example "Pay Day" to auto populate.