EXCEL cell Date

Hello,
Can you please help,
What is the formula to use to keep Excel cell C2 to always read the default date + 14.

the default date is   8/19/2013
so next change cell date  will be to 9/2/2013
next will be 9/16/2013
next will be 9/30/2013
next will be 10/14/2013
next will be 10/28/2013
and so on

thanks,
W.E.BAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ArgentiCommented:
$C$2 will keep the column and the row
$C2 will keep the column
C$2 will keep the row
0
ArgentiCommented:
Here you have an example
Dates.xlsx
0
W.E.BAuthor Commented:
hello,
but this requires me to use more than one cell.
the date CHANGE will always be in C2

Thanks,
0
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

ArgentiCommented:
You can reference your cell in any formula using $C$2+14.

If it's still unclear, can you please send me you Excel file?
0
W.E.BAuthor Commented:
thanks for your help,
please see sample attached.

Cell c2, right now, I change manually every 14 days.
sample.xlsx
0
ArgentiCommented:
I can see your spreadsheet and all other cells are referencing it using $C$2.

Now, how can I help you more?
0
W.E.BAuthor Commented:
cell c2,
how can it change automatically to  9/2/2013  when the date is 9/2/2013

then, next  change automatically to 9/16/2013 when the date is 9/16/2013
next  change automatically to 9/30/2013 when the date is 9/30/2013
next  change automatically to 10/14/2013 when the date is 10/14/2013
next change automatically to 10/28/2013 when the date is  10/28/2013

and so on
0
Don ThomsonCommented:
create a table like so in a hidden area

Column1
8/19/2013
9/2/2013
9/16/2013
9/30/2013
10/14/2013
10/28/2013
11/11/2013
11/25/2013
12/9/2013
12/23/2013
1/6/2014
1/20/2014
2/3/2014
2/17/2014
3/3/2014
3/17/2014
3/31/2014
4/14/2014
4/28/2014
5/12/2014
etc


in d2  =now()
in c2  = =+VLOOKUP(D2,Table2[Column1],1)
0
ArgentiCommented:
Here is what you should do, according to your provided file.

This way, your C2 cell will reference another fixed cell, and C2 will contain a formula that will update its value every 14 days.
sample-1-solved.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
W.E.BAuthor Commented:
Thank you very much for your time and help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.