In cell C2, enter: =TEXT(B2,"YYYYMMDD")&"-"&TEXT(ROW(),"000") This creates a unique pass like 20250320-001 based on date and row number.

inward gate pass format in excel download