I have a 24-tab worksheet. Each tab references information about a deliverable to our customer.
Example:
Filename | Due Date | Submission Date
Name1 | 06SEP13 | -
Name2 | 07OCT13 | -
Name3 | 07NOV13 | -
I'd like to have a cell at the top of each of the tabs to tell me when the next due date is. Here's what I've come up with so far, and I'm absolutely positive I'm over-thinking this, but I've hit a roadblock and need some fresh eyes on it:
=ADDRESS(MATCH(TODAY(),$B$4:$B$369,-1),2,4)
The value seems to return the correct cell address, B4. Now, I just need the contents of that address. When I wrap the above in =CELL("contents", <above_formula>), it returns an error.
What am I missing? Is there a shortcut that would make this simpler?
The end result will be that the first tab of the worksheet would reference each tab's "next due date" result of the formula above so that I can report status and project my deliverables.
Thanks in advance from a new user on the forum - hopefully I can pay the help forward.
Bookmarks