Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date entry automatically
I am creating a spreadsheet containing stats for a weeks work, broken down by
day. I will use the same spreadsheet each week, just replacing the dates. If I enter Monday's date, is there a way to make the rest of the week's dates automatically appear? And would this work if the Monday was the end of the month, like Mon 30 May? Thank you, Rob, Teesside, UK |
#2
|
|||
|
|||
You need only add 1 to Monday's date to get Tuesday, 2 for Wednesday, etc.
Thus, if you will place your Monday starting date in A2 - say 4/11/05, then B2 would contain =A2+1 and C2 would contain =B2+1 etc Doesn't matter where in the month your Monday falls, Excel will smoothly handle the change to a new month and even a new year. "abfabrob" wrote: I am creating a spreadsheet containing stats for a weeks work, broken down by day. I will use the same spreadsheet each week, just replacing the dates. If I enter Monday's date, is there a way to make the rest of the week's dates automatically appear? And would this work if the Monday was the end of the month, like Mon 30 May? Thank you, Rob, Teesside, UK |
#3
|
|||
|
|||
Wgere do I put the formula?
Thanks for your help, Rob, Teesside, UK "Duke Carey" wrote: You need only add 1 to Monday's date to get Tuesday, 2 for Wednesday, etc. Thus, if you will place your Monday starting date in A2 - say 4/11/05, then B2 would contain =A2+1 and C2 would contain =B2+1 etc Doesn't matter where in the month your Monday falls, Excel will smoothly handle the change to a new month and even a new year. "abfabrob" wrote: I am creating a spreadsheet containing stats for a weeks work, broken down by day. I will use the same spreadsheet each week, just replacing the dates. If I enter Monday's date, is there a way to make the rest of the week's dates automatically appear? And would this work if the Monday was the end of the month, like Mon 30 May? Thank you, Rob, Teesside, UK |
#4
|
|||
|
|||
OK -
1) Put your Monday date in cell A2 - and make sure Excel recognizes it as a date, not as text 2) in cell B2 type the following =A2+1 3) in cell C2 type the following =B2+1 and so forth "abfabrob" wrote: Wgere do I put the formula? Thanks for your help, Rob, Teesside, UK "Duke Carey" wrote: You need only add 1 to Monday's date to get Tuesday, 2 for Wednesday, etc. Thus, if you will place your Monday starting date in A2 - say 4/11/05, then B2 would contain =A2+1 and C2 would contain =B2+1 etc Doesn't matter where in the month your Monday falls, Excel will smoothly handle the change to a new month and even a new year. "abfabrob" wrote: I am creating a spreadsheet containing stats for a weeks work, broken down by day. I will use the same spreadsheet each week, just replacing the dates. If I enter Monday's date, is there a way to make the rest of the week's dates automatically appear? And would this work if the Monday was the end of the month, like Mon 30 May? Thank you, Rob, Teesside, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
Insert date automatically | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |