Hi John,

With dates in A and search date in B1:

=IF(MONTH(INDEX(A1:A39,MATCH(B1,A1:A39)))=MONTH(B1 ),MATCH(B1,A1:A39),MATCH(B1,A1:A39)+1)

Of course the formula can be much shorter if you use an extra cell for the

MATCH(B1,A1:A39)

part

--
Kind regards,

Niek Otten

"John Eppley" wrote in message ...
Hi: I have several workbooks which contain data sequentially entered by "date". It is necessary to determine the FIRST data
entry for a given month. For example, I may have a data entry for the first of the month "mm-01-yy". My equations work well for
this condition, but if there is NO data entry for the first of the month I do not know how to accurately find the row number of
the first month's entry.

John