View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Eppley
 
Posts: n/a
Default Row # of first "day" of current month.

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