barnettjacob/gist:fed9069d9f367b0b7aab

Created November 25, 2015 11:52

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

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

Download ZIP

Excel formula convert dates

Raw

gistfile1.txt

=YEAR(A1)&"-"&IF(LEN(MONTH(A1)) = 1, "0"&MONTH(A1), MONTH(A1))&"-"&IF(LEN(DAY(A1)) = 1, "0"&DAY(A1), DAY(A1))

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