How do I make one column of random dates automatically be two weeks in advance of the first column without the dates being sequential?

Question

I have one column of dates for paystubs for my clients, and I want the next column on the right to tell me when their next paystub is paid (in two weeks).

I will update the first column myself because this is the last paystub I have received from them. Then, I want the next column to update based on what I enter, two weeks ahead of the date I input.

I cant figure out how to do this because these dates are not sequential. They are all different.

(This post also MADE me pick a tag that is totally irrelevant, I dont get it....)

Answer 1

If we assume the dates you input are in A1:A10, then

• Enter "=A1+14" (without the quotes) in cell B1.
• Copy B1 to cells B2:B10

Whenever you update the date in a cell in column A, the corresponding cell in column B will automatically adjust to the date 2 weeks later.

Answer 2

Thank you! I am so new to this. It worked great!