How to put in a rolling 2 week time frame that pulls from 2 cells

[GBeau]

I'm looking to make a rolling 2-week deadline that pulls from 2 cells. It's for appointments, so I would put the date in the first cell, and I want the second cell to automatically generate the date 2 weeks from the first cells' date.

Ex. I put 1/23 into cell 1A and cell 1B autofills with the date 2 weeks out, 2/6.

Does anyone have any ideas on how to accomplish this? I've tried using =MOD(DATE(2007,2,25)-TODAY(),14)+TODAY() but the problem is it doesn't pull from cell 1A to auto generate into cell 1B. Any help would be appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=A1+14

 

[GBeau]

Hi & welcome to MrExcel.
How about

=A1+14

Thank you! This is helpful but I need something that applies to all the columns. Ideally I'd have one formula that I could copy so that all of A cells feed into the corresponding B cell. Each input for the A cells is usually a different date, so I can't have all the B cells pull from one A cell.

 

[Fluff]

Just drag the formula down col B.