And in fact you can just use Nories's LEFT(C6,10) directly in WEEKDAY function, so if Monday = 1 you can use

=WEEKDAY(LEFT(C6,10),2)