What is happening? I assume it has to do with the text month.
That's a good guess …
Let ( [
adj = Substitute ( Self ; "-" ; ¶ ) ;
monthName = GetValue ( adj ; 2 ) ;
~day = GetValue ( adj ; 1 ) ;
~year = GetValue ( adj ; 3 ) ;
monthList = "jan¶feb¶mar¶apr¶may¶jun¶jul¶aug¶sep¶oct¶nov¶dec" ;
~month = ValueCount ( Left ( monthList ; Position ( monthList ; monthName & ¶ ; 1 ; 1 ) ) )
Date ( ~month ; ~day ; ~year )
Works great, thanks! I'm going to have to take a few minutes to study this; I'm a bit handicapped with calculations.