I have a table that lists the every person in the company and the date they completed their last annual certification.
There are multiple annual certifications for each person.
The table looks something like following:
LastName, FirstName, Cert01, Cert01, Cert03, Comments
Johnson, Jack, 06/12/15, 01/30/15, 01/01/15, Comment
All dates are in the past. All certifications are annual.
I need to fill the cell of each certification date (the original cell) 3 months prior to their next annual, up until it will be due (which is 1 year from the original date).
Sorry, I get confused when trying to write the formula out...
Bookmarks