adding days to date

September 14, 2011 at 18:59:36
Specs: Windows 64
Using formula =E1+14 adds 14 days to E1. How do I apply that to multiple rows? without having to type in every cell? I did it once and now can't get it again. When I drag the box down to highlight multiple rows it changes them all to the same date. Also, it does not change when I enter in a new date.
Problem #1.
Ex. E1 has 9/14 F1 has 9/28
E2 has 08/12 F2 has 9/28
#2. When I enter new date in E1 (10/14) F1 stays 9/28
Any help would be great.

See More: adding days to date

September 22, 2011 at 20:55:47
My guess is that your Calculation option is set to Manual, not Automatic.

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

Report •
Related Solutions

Ask Question