Mar 21, 2013 at 3:09 PM
Edited Mar 21, 2013 at 3:12 PM
Let's concider this method
[ExcelFunction(Description = "The magic function")]
public static object ShowMeMagic(DateTime date)
object runResult = ExcelAsyncUtil.Run("MAGIC", date,
if (date >= DateTime.Today)
return "it will be magic ! "+date;
return "it was magic ! "+date;
I made an asynchronous excel function with Excel Dna. It works fine when passing a date as value.
But when when I test it with TODAY() and TODAY()-1 as parameters in two separe cells it turns into an infinite evaluation.