I have a 52 week calendar with weeks 1-52 in columns, and tasks listed in rows.
I cannot for the life of me figure out how to highlight cells based of the earliest entry on a task row. For example; Task A is scheduled to be completed once every 4 weeks. If the first occurrence of the task is week 2, then I would like to highlight week 6, 10, 14, etc...as being due for completion again.
Bookmarks