Formatting - Auto populate

[Daroh]

Hi

I have a formatting question, in Sheet1; column H (Due Date) and column I (Countdown to due date), I want date performed + 7 = Due Date and countdown = Today()-Due Date. I no I can use formulas but, is there a way to auto populate without dragging the cells down?

Thank you.