WEEKDAY Function in Excel

The WEEKDAY function in Excel takes a date and returns a number between 1 to 7 representing the day of the Week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. The WEEKDAY function can be used inside other formulas to check the day of the Week.
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #exceltip #exceltrick

[@khaliqahmad8844]

Instead of Index use =text(cell-reference-of-date,"date formate") like =text(D3, "dddd")

[@swamyjiki]

Exactly

[@wajidhussain6455]

This is what I came here but my eyes fell on your comments 🤣.

[@selvakumarm4382]

Yes

[@Anonymous-31]

@@wajidhussain6455 same as mine

[@TheUnknownAlways]

You can use the text function with the format

[@ya_yayjude3120]

The dollar signs on column and row in the formula is very important!!!

[@hemanthkify]

thank you that was helpful

[@jhonartcis8296]

you can use =text(A1,"DDDD") to get the the actual day

[@yuliakoval1214]

Man, you rock! Easy and clear! Cheers!

[@dhruvikagorai726]

Use text function

[@mohamedabdelrahman169]

Very useful 👌

[@soorajmohan8235]

Another simple way is copy that day of the week to week day. On week day colum press cntr & 1 together. In the list click custom. In the tight tab the digit appeared remove & add "ddd" & enter. You will get respectively week day

[@telmarinsgaming6801]

Super ji

[@luigibru8677]

Number Custom is another option

[@somsonang3509]

Teacher, I'm done, but it doesn't get, it show "#value!" , why?

[@archlab007]

Helpful video. But, Excel has been around +/-40years....it's just baffling that this isn't just a menu button. Instead, we have to go into setting up a series of functions & have to write, or load it anytime we hi just want something as simple as day of the week.

[@colin7021]

Could also use a custom number format of Ddd (to return "Sat") or Dddd (to return "Saturday") for the name of day.

[@ExcelBaba]

Yes but weekday will start from Sun=1, Mon=2 ..... Sat=7. Basically Ddd custom format will convert numeric values to 1st Jan 1900 starts from Sunday, 2 Jan Mon

[@SURAJSINGH-xv4fw]

Hi sir, can you tell how you recording excel sheet?

[@MrMandarpriya]

it is not at all working, it throws the error. So i guess

[@saiyadsabir]

Instead of this use TEXT function to get day name

[@cydeanlepon4315]

I totally agree. Text(date,"dddd")

[@2040rakesh]

How to convert calendar week number to date?

[@mvv1809]

Too lengthy process

[@kinanbarakat7777]

=text(weekday(date),"dddd")