Skip to content

Instantly share code, notes, and snippets.

@igos
Created September 15, 2020 09:02
Show Gist options
  • Save igos/52108c617aad584daa511698800035de to your computer and use it in GitHub Desktop.
Save igos/52108c617aad584daa511698800035de to your computer and use it in GitHub Desktop.
Przeliczanie wieku na podstawie PESEL , Google Spreadsheet
=YEAR(TODAY())-CONCATENATE(IF(VALUE(MID(N2,3,1))>1,"20","19"),LEFT(N2,2))
//Przeliczanie wieku na podstawie PESEL , Google Spreadsheet
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment