| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Range
I am doing an employee schedule and I want it set up so that when I change
the first date on the schedule the other dates automatically update as well. How do I do that? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Range
Do you want them to show up as the same date??
If you do, suppose A1 contains the date you want... in the cells with the dates that you want to change... input the formula =$A$1 Make sure to include the $ signs so you can drag the formula throughout all the cells that you want to change. "HRlady" wrote: I am doing an employee schedule and I want it set up so that when I change the first date on the schedule the other dates automatically update as well. How do I do that? Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Range
Provide some examples and your expect result
"HRlady" wrote: I am doing an employee schedule and I want it set up so that when I change the first date on the schedule the other dates automatically update as well. How do I do that? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
