Thread: Date Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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