Skip to content

Instantly share code, notes, and snippets.

@cederlof

cederlof/Get age from swedish personal number.xlsx

Last active December 6, 2016 14:19
Show Gist options
  • Save cederlof/4b0a92213dfa27f47c3d to your computer and use it in GitHub Desktop.
Save cederlof/4b0a92213dfa27f47c3d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Get age from swedish personal number.xlsx
=ROUNDDOWN((TODAY()-CONCATENATE(MID(A1;1;2);"-";MID(A1;3;2);"-";MID(A1;5;2))*1)/365,25;0)
(expects 2 digits for year)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment