Easy Excel formula

Job ID: 35431773

Budget: $15 – $25 CAD

I need an excel sheet where I can type in twenty names in 20 rows.

In the first column is the sales person name.

in the third column is their sales goal for the month. For example, $31,000.

In the second column is an automatically updating daily goal based on how they did the day before.