Excel Weekday Function Part 1 | How to use the WEEKDAY Function in Excel with IF Function

In this video you will learn how to use the weekday function in excel as it returns a number based on the day of the week.
1. Excel weekday formula
2. Excel weekday formula with if function
3. How to find the days are weekday or weekend using weekday function
4. Weekday function with explanation and example in excel
5. Best use of Excel weekday formula example

Download the Assignment Master Practice Folder here (All Playlist Example at one place)

Let's Connect:

#weekdayfunction#datefunction#Innozant #Excelformulaandfunction

[jyotishkumaryadav]

Hello sir,
Thank you so much
🌹🌹🌹🌹🌹

[hemantgusain]

Thanks you sir for explaining weekday function, earlier I did not know where to use this formula.

[learntoteach]

Sir pls combine all basic video series to one video.

[sandeepaswal]

Sir You are Excellent tutor, you explain formula so clearly .your way is simple to understand.

[farhandelhi]

Thank you bhaiya aapne bhot acche se explain kiya easily sb smjh aa gaya hai.

[vijaysahal]

you are amazing sir nd you teaching way is also unique 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻💯

[devarasettisunitha]

I am thankful to you very much sir i am searching for many videos nd finally i got ur video it helped me a lot...

[maryparmar]

This really useful, used this function to calculator turnaround time, Thank you for the explaintion.

[muhammadsaqlain]

sir apka bolnay ka andaaz bilkul shahrukh khan ki tarah hai very well sir.

[Sarwasyapi-bhawedhwetu]

Thank you thank u sooo much sir i was really looking for this exact problem n u cleared it. Just keep going 👍

[mohammadsaifulislam]

Just Awesome!!!! Learned something different.

[RohitKumar-cczi]

You are always Owsome sir, there is no dought 👌👌

[Altaf_Alam]

Sir in the place of nested if, can we use or function
Eg. - 3
=If(or(weekday(A1)=1, weekday(A1)=7), "weekend", "workday")

[ArunKumar-vvnn]

Sir Ek Tutorial....VBA Coding Ka Bhi Banao

[hffbtjs]

Sir how please explain the formula to find out specific dates for lesson plan

[LEFTMAXI_RM]

Sir.. how to convert daywise datas into weekly data. pls share a video for this.

[harivanshgautam]

Perfect video Sir about weekday and nicely combined if function with weekday. Very good video 🙏

[nishijadaun]

Sir, agr weekday Tuesday se start ho to????

[pawanwakale]

sir you gave one practice sheet, In the video you explain in weekday by default its taking Sun 1 and saturday 7, while practicing when doing example Mon, oct 23, 2017 =weekday() it must show 2 but its showing #value

[Sarwasyapi-bhawedhwetu]

Sir what if, nested if ki jagah "or" function ka use kiya jaye weekend aur workday nikalne me. I have tried but did not work.