I have a formula that calcs days on job from hire date. So I have a
column with hire date, a cell off to the side with todays date and a
column with days on job. My formula is =DATEDIF(E2, K2, "D") and it
works fine, but I have 130 employees and I want to copy this formula
to each of them, but when I do, excel automatically changes the E2,K2
to the next cell. I want it to change the E to the next cell, but
leave the K as 2. Can this be done automatically?