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

ID: Q33242

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("date",INPUT("Enter a search date:",1))
   =FORMULA.FIND(TEXT(date,"m/d/yy"),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 :