Skip to content

Instantly share code, notes, and snippets.

@barnettjacob

barnettjacob/gist:fed9069d9f367b0b7aab

Created November 25, 2015 11:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save barnettjacob/fed9069d9f367b0b7aab to your computer and use it in GitHub Desktop.
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