Question : how to get day from date in excel
Answered by : sri-harsha-nagulakonda
=TEXT(A1,"d-mmm-yyyy") // returns "1-Jan-2000"
=TEXT(A1,"mmmm d, yyyy") // returns "January 1, 2000"
=TEXT(A1,"mmmm") // returns "January"
=TEXT(B5,"dddd") // returns "Saturday"
=TEXT(B5,"ddd") // returns "Sat"Source : https://exceljet.net/formula/get-day-name-from-date | Last Update : Wed, 29 Jun 22