Microsoft KB Archive/33242

{|
 * width="100%"|

Excel: Finding a Date Using FORMULA.FIND in a Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

-

SUMMARY
To use =FORMULA.FIND in a macro where the search date is defined as a name, you will need to use the following macro steps:

  =SET.NAME(&quot;date&quot;,INPUT(&quot;Enter a search date:&quot;,1)) =FORMULA.FIND(TEXT(date,&quot;m/d/yy&quot;),2,2,1)

The first macro step defines a name to be the serial date for a date input by the user. The second macro step converts that date to a proper format and searches for matching values in the active window.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :