Date Range

[Guest]

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

 

[Guest]

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.

 

[Guest]

Provide some examples and your expect result