View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TechTrend TechTrend is offline
external usenet poster
 
Posts: 3
Default Find the position of a date

Perfect! , Thanks again

This is what I was looking for:

"If you also want "doesn't exist" if B1:B2 is later (more recent) than
the first month/year represented in A1:A100, then:

=IF(OR(DATE(B2,B1,1)<A100-DAY(A100),DATE(B2,B1,0)A1-DAY(A1)),
"doesn't exist", MATCH(DATE(B2,B1,1),A1:A100,-1))


Cheers