EXCEL cell Date

$C$2 will keep the column and the row
$C2 will keep the column
C$2 will keep the row

Here you have an example
Dates.xlsx

hello,
but this requires me to use more than one cell.
the date CHANGE will always be in C2

Thanks,

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?

thanks for your help,
please see sample attached.

Cell c2, right now, I change manually every 14 days.
sample.xlsx

I can see your spreadsheet and all other cells are referencing it using $C$2.

Now, how can I help you more?

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

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)

Thank you very much for your time and help.