Hello,
I need a formula that will: look at several columns, determine what month is listed in the columns and compare dates in separate columns (see below).
A B C D E F G
1 Name 1/10/10 1/9/10 3/10/10 3/7/10 6/10/10
The formula needs to look at B, D, F to determine what month the project is due and if it has already been completed (C, E, G). If it hasn't been completed then on a separate sheet it would list by month the project due date.
A B C D E F G
January February March April May June July
Name
Nothing would return for Jan-May since they have been completed.
I would appreciate any help. Thanks.
Bookmarks