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)
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)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks