Thread: Cell to display one of twelve cells that have data..

Originally Posted by kAustin79

I have a column with twelve cells. At any given time, one of these cells will have a date in it. There will only be one that can have a date at a time. What I want to do is to is have a cell that will display the date from the one cell.


Something like this:

Cell A1 = which ever cell between B1 - B12 has a date in it.

Help on this would be greatly appreciated

=Sum(B1:B12)

---