| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically update a cell with a date based on anther cells date
I have a basic time sheet that is used to track time for payroll. The sheet
has Mon- Sun and on each day there is a cell for the date. There is also a cell for week ending date. What I am trying to do is insert the week ending date and have the other cells update with the previous week. Example: Enter week ending date here - 11/02/2008 The other cells would auto fill based on the week ending date. As shown below: Mon 10/27/2008 Tues 10/28/2008 Wed 10/29/2008 Thru 10/30/2008 Fri 10/31/2008 Sat 11/01/2008 Sun 11/02/2008 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically update a cell with a date based on anther cells date
One way:
Assume week end date is in A1. Monday: =A1-6 Tuesday: =A1-5 Wednesday: =A1-4 .... Format the cells as dates if necessary. In article , GPR GUY <GPR wrote: I have a basic time sheet that is used to track time for payroll. The sheet has Mon- Sun and on each day there is a cell for the date. There is also a cell for week ending date. What I am trying to do is insert the week ending date and have the other cells update with the previous week. Example: Enter week ending date here - 11/02/2008 The other cells would auto fill based on the week ending date. As shown below: Mon 10/27/2008 Tues 10/28/2008 Wed 10/29/2008 Thru 10/30/2008 Fri 10/31/2008 Sat 11/01/2008 Sun 11/02/2008 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically update a cell with a date based on anther cells date
Hi,
Assume Mon is in A1 and your week ending date is in D1 then enter =D$1 in cell A2. Highlight A1:A2 and drag the fill handle down as far as necessary. -- Thanks, Shane Devenshire "GPR GUY" wrote: I have a basic time sheet that is used to track time for payroll. The sheet has Mon- Sun and on each day there is a cell for the date. There is also a cell for week ending date. What I am trying to do is insert the week ending date and have the other cells update with the previous week. Example: Enter week ending date here - 11/02/2008 The other cells would auto fill based on the week ending date. As shown below: Mon 10/27/2008 Tues 10/28/2008 Wed 10/29/2008 Thru 10/30/2008 Fri 10/31/2008 Sat 11/01/2008 Sun 11/02/2008 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Date Cell when any of target cells change | Excel Worksheet Functions | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| Automatically insert a date value based on the value from another cell | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
Linear Mode
