IsValidPESEL

Opis:

ISVALIDPESEL is a formula that checks whether the given PESEL number (Polish National Identification Number) is valid according to applicable rules. The function analyzes whether the provided value consists exactly of 11 digits, contains no letters or special characters, and whether it passes the checksum algorithm based on the official rules applied to PESEL numbers.

Only space formatting characters are allowed – they are ignored during validation and do not affect the function result.

Please note that the function does not verify whether the given PESEL actually exists or is registered in the national registry. The function’s operation is limited exclusively to verifying the correctness of the structure and format of the number.

Syntax:

IsValidPESEL (value)

Parameters:

value

(type: text) text or reference to a cell containing the PESEL number to be checked

Return type:

Logical

Example:

=isvalidpesel('92070803628')
=isvalidpesel(section2.B2)
=isvalidpesel(a)