Are you trying to get the day of the week like Monday, Tuesday and so on..? If yes, below is the code, if just the day number - Fotis has already answered it.
=TEXT(A1,"dddd")  ' returns Monday

or 

=TEXT(A1,"ddd")  ' returns Mon