The main problem is not the format of date (dmy or mdy or ymd) nor if monday is the first day of the week, but identify the day '2010-2-1' as monday.

DECLARE @d as datetime

set @d = '2010-2-1'

SELECT cast(@d as int) % 7 + 1

This identifies Monday as 1.