Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // EXCEL FORMEL TIL OMREGNING AF CPR TIL ALDER MED UDGANGSPUNKT I DD.
- =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