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
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
cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks