Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto dating after entering the first date
I have a Timesheet that has a row of dates for a two week period, I would
like to enter the first date and have the rest of the remaining days auto compute the correct date. I used to have a Timesheet that had a formula for this but I'am no longer able to find it. Thanks |
#2
|
|||
|
|||
Jomo Watts wrote: I have a Timesheet that has a row of dates for a two week period, I would like to enter the first date and have the rest of the remaining days auto compute the correct date. I used to have a Timesheet that had a formula for this but I'am no longer able to find it. Thanks If your date appears in cell A1, for instance, then cell A2 could contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy down as many rows to complete your two week period. |
#3
|
|||
|
|||
Thanks Fred it worked perfect!
"Fred" wrote: Jomo Watts wrote: I have a Timesheet that has a row of dates for a two week period, I would like to enter the first date and have the rest of the remaining days auto compute the correct date. I used to have a Timesheet that had a formula for this but I'am no longer able to find it. Thanks If your date appears in cell A1, for instance, then cell A2 could contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy down as many rows to complete your two week period. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set an auto date function in excel or word? | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
auto entry of a date | Excel Worksheet Functions | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |