Return first date populated

[Pleasehelp via OfficeKB.com]

I have a spreadsheet with 24 months across the columns. The rows contain
customer names. The cells contain data beginning with the date that amounts
were transferred into the department. Is there a function that will allow me
to look across the columns and return the first date that is populated? I
tried to use a conditional if statement, but the number of periods are
greater than the number of conditions allowed?

 

[The Code Cage Team]

How is the data laid out in your workbook?, are dates in their seperate
cells?

I have a spreadsheet with 24 months across the columns. The rows
contain
customer names. The cells contain data beginning with the date that
amounts
were transferred into the department. Is there a function that will
allow me
to look across the columns and return the first date that is populated?
I
tried to use a conditional if statement, but the number of periods are
greater than the number of conditions allowed?

--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)

 

[Pleasehelp via OfficeKB.com]

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.

How is the data laid out in your workbook?, are dates in their seperate
cells?

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)

 

[T. Valko]

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

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.

How is the data laid out in your workbook?, are dates in their seperate
cells?

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)