Excel Weekday Function Part 1 | How to use the WEEKDAY Function in Excel with IF Function
HTML-код
- Опубликовано: 7 фев 2025
- 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)
drive.google.c...
(Playlist Folder-Basic Excel-Date & Time Function-weekdaypart1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#weekdayfunction#datefunction#Innozant #Excelformulaandfunction
IF(OR(WEEKDAY(A21)=1,WEEKDAY(A21)=7),"weekend", "workday")..Sir, We can also combine OR function and Make it shorter,
You are BEST teacher of EXCEL..✍Thank you 😇
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...
Thanks Sunitha...Keep Learning ❤️👍 Keep Exploring
This guy is a true legend 🙏
Thanks dear❤️Really means a lot to me
Ur xplntn r awsm 👌👌👌
Thanks Ali
Thank you bhaiya aapne bhot acche se explain kiya easily sb smjh aa gaya hai.
Well explained carry on
Thank you thank u sooo much sir i was really looking for this exact problem n u cleared it. Just keep going 👍
Thanks Rangoli.Kerp learning ❤️😊 l
Amazing guru ji ❤️❤️
Hello sir,
Thank you so much
🌹🌹🌹🌹🌹
Thanks Jyotish ,Hope apko Video samjh aate honge aur aap usse seekhna start Kar Diya Hoga.Steo by step seekhiye Basic Excel Playlist se pehle start kijiye
Ek number sir
Thanks Dear
sir apka bolnay ka andaaz bilkul shahrukh khan ki tarah hai very well sir.
Hahahaha ❤️😅
Sir pls combine all basic video series to one video.
Thanks you sir for explaining weekday function, earlier I did not know where to use this formula.
Just Awesome!!!! Learned something different.
you are amazing sir nd you teaching way is also unique 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻💯
Thanks Vijay ji for your such a lovely appreciation.Really means a lot to me
Jabardast guru ji👌🏻
Thanks Puran❤️🙏
Excellent SIr
Thanks dear
Sir You are Excellent tutor , you explain formula so clearly .your way is simple to understand.
This really useful, used this function to calculator turnaround time, Thank you for the explaintion.
Thanks Mary..Happy Learning..God Bless You.. Never stop Learning..Make it habbit❤️❤️🙏🙏
thanks a lot sir
Sir Ek Tutorial....VBA Coding Ka Bhi Banao Plz......
Bana diya hai dear ..video playlist hai aage videos upload hote rahenge
@@Innozant ...Apki Videos Dekhkar He Sir.... Excel Samajh Mein Aaya Hai....Or Aap Explaination Bahut Achha Hai Sir....Bas Ab VBA Macro Coding Ki Videos Chahiye
You are always Owsome sir, there is no dought 👌👌
Thanks Rohit ji🙏❤️
Very useful
thanks brother for the video
Thanks Sir.
Thanks Tarun ji
Sir you aur best explain teach sir
Thank you sir
Sir how please explain the formula to find out specific dates for lesson plan
Super sir
Thnq sir so much
Thanks Gaurav Ji♥️🙏
Thank u:-)
Good Morning..Have a great day
Sir kya isme array b lga skte hai kya..1 to 5
yahan array use krne ka kki benifit nhi hoga priyanka
@@Innozant ok sir
Thank you for this video 🔥
Thanks Vikash ji.❤
Perfect video Sir about weekday and nicely combined if function with weekday. Very good video 🙏
Thanks Dear,Hope you are learning these functions every day and gain knowledge.
@@Innozant yes sir🙏
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
Because date format is wrong..kindly check the date value.
❤️❤️❤️❤️❤️
But sr in your starring video Weekday formula is not working in my laptop and the give me meny Times
#Value!
Time 2:38
Date ka format galat le rahe hain dear isliye value error..check your date
Nice
👌👌👌👌
Opps! you did the same thing I just write my ocmment 2 mins before. lolzzz
Good .Keep learning 👍❤️
Sir.. how to convert daywise datas into weekly data. pls share a video for this.
Sir, agr weekday Tuesday se start ho to????
Sir agar return type 12 ho jisme Tuesday se starting hoti hai jaha tuesday 1 aur monday 7 , isme if condition kaise lagayenge, ya multiple kyoki saturday 5 aur sun 6 and back monday 7 isme condition kaise use karenga
And operator use kar sakte hai kya ?
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.
Sir Aap HTML ka bhi video bhejiye
Sir mai same date dal ker formula apply ker raha hoon lekin#value likh ker aa rahaa hai
suprb :)
Thanks Aakanksha ,Hope You understand and like the concept of weekdays function.
Nice Job sir, But can't we do it with one if function like if(weekday(date()
❤️👍
Sir in the place of nested if , can we use or function
Eg. - 3
=If(or(weekday(A1)=1,weekday(A1)=7),"weekend", "workday")
Good night sir
Ok.Satish Ji,Good Night.Happy learning
Hello Sir, Really useful, but doesn't work in my Daily Time Log Book,
In my company every Saturday is an alternate weekend, suppose 1st Saturday is working day then 2nd Saturday will weekend. can you guide me on how can I use the formula for that type of Sheet. Thank you.
Use workday.intl and pass custom weekend parameter 0 and 1 as per your requirement.
=IF(OR(WEEKDAY(D6,2)=6,WEEKDAY(D6,2)=7),"weekend","workday") sir i applied this formula ,,is this right?
Mere excel me return type ka optn nahi derai?
Brother, how to find monthly week number. Incase Month period is between to calendar month. For example: 11-July-2022 to 10-Aug-2022" means Jul 11 to Jul 17 is week 1, Jul 18 to Jul 24 is Week2, Jul 25 to Jul 31 is week 3, Aug 1 to Aug 7th is week 4 and finally Aug 8th to Aug 10th is Week4.
How to find last Sunday in a month... please reply and write the formula please help me 🙏
=EOMONTH(DATE(2021,{1;2;3;4;5;6;7;8;9;10;11;12},1),0)-WEEKDAY(EOMONTH(DATE(2021,{1;2;3;4;5;6;7;8;9;10;11;12},1),0)-A1,3)
In A1 cell type weeknumber and make a drop down to choose laste day
Good afternoon Sir,
How to get end date and time if i have start day and time together and to add "n" working hours excluding non working hours.
example 1) if start date=02/06/2022 02:00 and to add 4:00 working hours and the working hours are from 08:00 to 18:00 and the non working hours to be excluded are of from 18:00 to 08:00 and the end date should be like 02/06/2022 12:00. what is the formula for this one sir.
2) if start date=02/06/2022 16:00 and to add 4:00 working hours and the working hours are from 08:00 to 18:00 the and the non working hours to be excluded are of from 18:00 to 08:00 and the end date should be like 03/06/2022 10:00. what is the formula for this one sir.
In CCC to be completed time also same formula given sir.
Can u please help me with the formula sir?
Sr week number formula how to use sr plz video bna do
Weeknum ka ise btaya hua hai..ok seprate bna dete h ek video
SAMJHANE KE TARIKE KO DHANYABAD
Thanks Gyan Chand Ji.happy learning♥️🙏
Sir comma lgane k bad list open nhi huyi
Plz reply sir🙏
Why..which version of office you are using
Sir mujhe auto fill date chaiye but Sunday ko chor kar
Constraints hain phir custom function use kriye nhi sirf fill Krna hai to flash fill
Sir mera weekday ke function me error show ho raha hai
Value nahi aaraha error show ho raha hai ( #value! )
Date format wrong hoga..us date par click krke use number me display kariye pehle..ki number show ho ra hai ya text
jkflvJADsjf
Amazing guru ji ❤️❤️
Bhai main jab weekday number ka formula lga rha hu to #value show ho rha h
Date format is wrong