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

ID: Q33242


The information in this article applies to:


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        : 

Last Reviewed: March 12, 1999