How To Carry Forward Dates In Excel?

Question

I know this formula is simple and I used to know it. But I forgot. Researching it online hasn't helped me find the formula or jog my memory. I have a date in another sheet called WEEK 1. In the sheet called WEEK 2, I want to enter a formula that adds 6 days onto the date from the WEEK 1 sheet. That way, when I change the date in the WEEK 1 Sheet it will automatically change the date in the WEEK 2 Sheet as well. And so on, and so forth.

THE DATE IN THE "WEEK 1" SHEET IS JANUARY 30, 2021 (see screenshot).

I JUST WANT TO CARRY IT FORWARD TO THE "WEEK 2" SHEET AND ADD 6 DAYS (see screenshot). My Formula is =DATE('WEEK 1'!E1:')+6 does not work.

Thank you for any and all help everyone!!!!!!

Answer 1

Hi there

Try simply by selecting cell E1 on the WEEK 1 sheet and add 6

I.e.

='WEEK 1'!E1+6

That will do

Regards

Jeovany

Answer 2

PERFECT IT WORKED. THANK YOU. I knew it was a simple formula and I almost had it. I just couldn't recall the whole thing.