Solved Auto update date in excel

December 9, 2015 at 20:08:56
Specs: Windows 7
I want to have a "code" change a date for a followup field.

for instance

Date - 12/9/2015
Code - C1
it automatically adds 1 day to the "followup" field
Code - C3 adds 7 days
etc

can anyone help with this?


See More: Auto update date in excel

Report •


#1
December 10, 2015 at 03:52:00
i dont understand what you mean, can you please explain with a lot more detail. Please remember we cannot see your workbook so have no idea how it looks or what the fields are.

Code - C1

Code - C3

no idea what you mean by this......


Report •

#2
December 10, 2015 at 03:53:14
✔ Best Answer
When you use the word "code" I assume you mean "formula", correct?

The word "code" is usually used with VBA or other programming languages.

Each day in Excel is equal to "1". You can simply add 1 (or 7) to a cell to increase the date.

=C1+1

This site might help...

http://www.cpearson.com/excel/datet...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question