I am using a separate index/match scenario where the date is one of the fields I am matching. I want to embed into the formula a function that will pull the date in the below table where there is data in the 4 columns next to it. Need a formula that will pull 12/14/2011 since that is the latest date where there is date in columns B, C, D, E
12/09/2011 7591 12915 0.9677 0.9981
12/10/2011 7591 12915 0.9677 0.9981
12/11/2011 8664 14809 0.9685 0.9984
12/12/2011 10066 17102 0.9725 0.9985
12/13/2011 11550 19517 0.9635 0.9985
12/14/2011 12844 21705 0.9631 0.9986
12/15/2011
12/16/2011
12/17/2011
12/18/2011
12/19/2011
12/20/2011
Thanks!
Bookmarks