wisaruthk/gist:fd611bdb564dfa71c247ca6a47ce00bd

Last active September 1, 2020 07:58

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wisaruthk/fd611bdb564dfa71c247ca6a47ce00bd.js"></script>
Save wisaruthk/fd611bdb564dfa71c247ca6a47ce00bd to your computer and use it in GitHub Desktop.

Download ZIP

string to date excel

Raw

gistfile1.txt

	dd.mm.yy
	to excel date

	=DATE("20"&RIGHT(B2,2),MID(B2,4,2),LEFT(B2,2))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment