| View previous topic :: View next topic |
| Author |
Message |
taijim
Newbie
Joined: 18 Jun 2012
Posts: 2
|
 Posted: Mon Jun 18, 2012 12:42 am Post subject: Duplicating formula -Count days from start date |
 |
|
Given that column A contains dates and column F should contain "Number of days since A2", is there a shortcut to duplicate the formula "A2-A2" in F2 so that subsequent rows will show "A3-A2" "A4-A2" etcetera?
For instance, in the date column, I can select the first two date cells and drag them down to set a consistent date separation (1 day, 3 days, 7 days or even same day in subsequent months). Is there a similar short cut for (Days from Start date)? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
taijim
Newbie
Joined: 18 Jun 2012
Posts: 2
|
| Posted: Mon Jun 18, 2012 3:16 am Post subject: |
|
|
Thanks for the quick and useful response!!!.
Interpreting that recipe, I used the formula "=A2-A$2" in the first cell.
When copying down, "A$2" was resolved as "the value of cell A2" and A2 was resolved as "the value of cell An where n is the current row - which is exactly what I needed. i.e. current date - start date. |
|
| Back to top |
|
|
|
