In the example below I have enter in a data array the scores for various playoff games as they happened. The date in column A is the scheduled game date. Some games are rained out, some get scores. In the title of the summary sheet I would like a formula to give me the date of the last game played. In this example that date would be 6/14/2012. This is a dynamic list so every time the data for a completed game (or rain out) is entered then that date should update itself.
Any help would be very much appreciated,
Thanks,
Joe
Any help would be very much appreciated,
Thanks,
Joe
DATE</SPAN> | DAY</SPAN> | GAME</SPAN> | RO</SPAN> | SCORE</SPAN> | WIN</SPAN> | LOSS</SPAN> | TIE</SPAN> |