Created
June 2, 2023 02:18
-
-
Save ken-itakura/de65a28d033a5a44d3a5cfcbe59a73f4 to your computer and use it in GitHub Desktop.
Excel function to convert date string (mmm/d/yyyy like AUG/31/2021) to Date format
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function MMMDDYYY_to_DATE(datestr As String) As Date | |
| Parts = Split(datestr, "/") | |
| datestr = Parts(2) & "/" & Parts(0) & "/" & Parts(1) | |
| MMMDDYYY_to_DATE = DateValue(datestr) | |
| End Function |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment