Advertisement
Guest User

Excel CPR-formel

a guest
Jan 23rd, 2020
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. // EXCEL FORMEL TIL OMREGNING AF CPR TIL ALDER MED UDGANGSPUNKT I DD.
  2. =DATEDIF(DATE(IF(MID(A1;5;2)<=RIGHT(YEAR(TODAY());2);"20"&MID(A1;5;2);MID(A1;5;2));MID(A1;3;2);LEFT(A1;2));NOW();"y")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement