Excel tip to get day of the week from a date

In this Excel tip, we'll show you how to get the day of the week from a date. This tip is handy if you need to find the day of the week for a particular date.

If you need to find the day of the week for a date, then this Excel tip is for you! We'll show you how to get the day of the week from a date in Excel using a simple formula. After watching this video, you'll be able to find the day of the week for any date quickly and easily!

#excel #exceltips #exceltricks

[BenDieselBasicAutomotive]

Thank you very much for the technique....

[jewlstagara]

how do you exclude weekends from the word/string column ? seems like you can auto generate days of the week unless it's in number format can't find anything on this.

[jbetts]

My only concern is I want the day of the week to auto-populate when the date is entered. If I drag that function down for the rest of the column, I get "Saturday" listed when the date isn't present

[Raaz]

And if we want to reverse it. Means to add date by day then

[imsingle]

Plz maam How can I capatilize Day after this foromula

[wasisahab.]

Mam date nhi hone par Saturday aa raha..