Excel: Finding a Date Using FORMULA.FIND() in a MacroID: Q33242
|
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)
Additional query words:
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 12, 1999