# Auto-fill cells with Dates based on another date cell

1. ## Auto-fill cells with Dates based on another date cell

Hi -

I'm creating a task-list template in Excel 2013 and would like to DATE my tasks based on the date of the events. For example:

B4: DATE OF EVENT

C8: Task D8: Date it's due (B4 minus 4 weeks)
C9: Task D9: Date it's due (B4 minus 3 weeks)
C10: Task D10: Date it's due (B4 minus 5 days)

And so on.

What formula would I use in the D column, so the due dates are automatically filled in based on the event date? Any help would be greatly appreciated.

2. ## Re: Auto-fill cells with Dates based on another date cell

dates are serial numbers based on 1/1/1900 (number of days since 1/1/1900) so all you have to do is subtract from B4 the number of days, therefore if B4 is 4/1/2013 then 4 weeks would be 4*7=28 so the formula would be =B4-28 (3/4/2013) to get the due date.

D8=B4-28
D9=B4-21
D10=B4-5

3. ## Re: Auto-fill cells with Dates based on another date cell

what is in the C column?

4. ## Re: Auto-fill cells with Dates based on another date cell

I think you read it correctly. Column C is the task, that will remain as a constant in the template.

Column D will be the date that changes, based on the event date entered in B4.

There are currently 1 users browsing this thread. (0 members and 1 guests)