Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • Had to add PtrSafe before each Declare on my system. Commented Oct 17, 2017 at 23:14
  • 4
    Yeah, this doesn't work. If you add a test Dim d8 As Date: d8 = ISODATE("2020-01-02T16:46:00") that is a valid ISO date for 2nd of Jan, bit it returns 1st Feb... Your tests are very optimistic. Commented Jul 31, 2018 at 13:03
  • See stackoverflow.com/questions/42534508/… for how to make the new function permanently available in Excel. Commented Nov 27, 2023 at 8:29
  • @Raman Just change the first declarations into Public Declare PtrSafe Function ... Commented Nov 2, 2024 at 13:50