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.
Bookmarks