I see now, the dates are the column headers.

The array formula** I suggested will do what you want. Just change the
references to suit.

=IF(COUNT(B2:G2),INDEX(B$1G$1,MATCH(TRUE,ISNUMBER( B2:G2),0)),"")

Format as Date

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.


--
Biff
Microsoft Excel MVP


"Pleasehelp via OfficeKB.com" <u27204@uwe wrote in message
news:953ee28251ebc@uwe...
Dates are arranged in ascending order in Row 1. The data contained in the
cells is the $ value of the receivable as of that date. It is column H I
am
trying to populate.
A B C D E
F G H
Acct # Name 11/30/2008 12/31/2008 1/31/2009 2/28/2009
3/31/2009 1stDate
1234567 ABC Co
$10,001.
27 $10,001.27 2/28/2009
2345678 BCD Co
$47,
161.57 $47,161.57 2/28/2009
3456789 CDE Co $10,000.00
12/31/2008
4567890 DEF Co $5,500.00
???

Thanks.


The Code Cage Team wrote:
How is the data laid out in your workbook?, are dates in their seperate
cells?

Pleasehelp via OfficeKB.com;324122 Wrote:
I have a spreadsheet with 24 months across the columns. The rows
contain
[quoted text clipped - 11 lines]
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1