Is there a way to have time spread across columns named by Week. For example
I want to show 20 hours for a job, but it should be alotted between 2 weeks
by due date.

A1 = Due Date
A2 = Number of Hours
A3 = Wk 1
A4 = Wk 2
A5 = Wk 3

Time would be spread out through a 2 wk period with due date during Wk 2.

Thank you,
Sandi