Excel formula - Redcrest-Solutions/FlyingFleet-issues GitHub Wiki

Check if A1 is of format MM/DD/YYYY and transform it in local date, otherwise take cell

=IF(ISNUMBER(FIND("/",A1)),DATE(RIGHT(A1,4),LEFT(N40,FIND("/",A1)-1),MID(A1,FIND("/",A1)+1,2)),A1)

insert member for given cells

="INSERT INTO Members(Title,LastName,FirstNamer,Email,Phone,Address,ZipCode,City,Country,	AllowEmailNotifications,Birthday,IsActive) VALUES('"&C1&"','"&D1&"','"&E1&"','"&F1&"','"&G1&"','"&H1&"','"&I1&"','"&J1&"','"&K1&"','"&TEXT(N1,"YYYY/MM/DD")&"');"