Sir mje aisi sheet bnani hai jaha pr bar bar month na chng krna pde automatucally month year sb chng ho jae or jo extra holodays pdti hai wo bhi sheet pr dikhe
asalam u alikum bhai me conditional formating apply kar raha hon sunday k liye but colour apply nae ho raha. ap mujhe kuch suggest kary k me kiya karon. mere pass excel 2013 hn.
@@shahabislam4912 Dear Sir, Heartily Thank you for kind reply and Valuable. I will try to make it one legal Paper is there any issue then I will keep issue over here Kind Regard, Basavaraj
Hello sir canteen stock items kaise Entry karte Hain .or kaise issue karte Hain .kripya bataye sir .I am Ronit Kumar from Gujarat India . thank you sir
How to repeat IF formula in same cell many times for getting different logical values for different criteria. Or simply how to use IF formula many times in same cell. Plz help.....
Can you please tell me if half days available in the attendance sheet . So how to calculate the total working days because we have to deduct the half days from total working days.....Please reply soon or upload related video.....
No this format is not in excel, you can use only this format 1-jan-18 or other format you can check in number format. and any thing want to know about excel please comment.
=OrText($B$3,"DDD") ="SAT",text($B$3,"DDD")="SUN" Hi..am having a problem with this fourmula..to highlight Saturdays and sundays..can you please help me
Assalam o Alaikum. Shahab Islam bhai aap ki attendance sheet wali videio bohot achi lagi. bus itna bata dain kay total present walay column may agar hum sunday ko bhi include kerain to kesa hoga. please ismael.cttc@gmail.com per zara tafseel say email kerdijiye ga. ALLAH JAZA E KHAIR day aap ko
Good
sir video kamal ki hai
Very Good Teaching Sir Shahab
MASHALLAH
good job
JAZAKALLAH KHAIR
Thank you so much sir
Sir ager new Month k liya bana hai usky liya same procedure copy krna hoga?
Thank you sir!!
Most welcome!
Great
Informative
Thank you , Shahab Islam Bhahi very Great Work.
Ghazab
great work
bs sunday wala step mra ni hota pta ni ku
JIs Trha se Step Hen. same Kare Hojega.
Great Work for the people and i appreciate personally you to upload the knowledgeable video
Sir awsm video but I thought ki apne month Ka formula liya he to month. Change kara to sheet change nhi hota
Sir mje aisi sheet bnani hai jaha pr bar bar month na chng krna pde automatucally month year sb chng ho jae or jo extra holodays pdti hai wo bhi sheet pr dikhe
SIR APNA JO SUNDAY KO FORMAT KARNA KA TAREKA BATA YE THI PLZ WO FORMULA AP MUJ BATA HAI GI
asalam u alikum bhai me conditional formating apply kar raha hon sunday k liye but colour apply nae ho raha. ap mujhe kuch suggest kary k me kiya karon. mere pass excel 2013 hn.
Wow 🎉😮
Sir bhot hi zabardast video hai
Per plz thora zoom.kiya kare
thank you, I want to know that we are giving day off for our staff different days, not only sunday. how we mention it on excel?
Thank y0uu s0o much ♥️
🥰🥰🥰🥰🥰🥰🥰🥰
Nice but very slow
I like your video and I learnt but please explain it more clearly...thank you
Thank you so much sir for making this video ALLAH aap ko jazaye khair de subscribed your channel proudly
nice video thanks
Very good
Thanks very good dear teacher
Assalamualaikum Sir thanks for subscribe this video..sir aap bohar eazy methods se samjate hoa laiken screen clear nahi aare sir yeh video ke
Aik month ke leave or dosary month ke leave ko link kirny k leay k remaining leaves kitni hyn kiya kiryen gey
good work
well method
Boss mujhe jo aap highlight karte Hai na Sunday Ka oo farmulla jo - singh Hai samjh me nahi Ata Hai kaha pe Hai.. Please tell boss
c$6 Jo BHi Sunday cell address hoga ispa column wala hata den is tarha row wala lagega c$6
Thank you so much
Sir thoda zoom karke video dikhaye words clear nahi aare sir p/zz..jazak Allah hu khair
Dear Sir,
Can I put one month same format (above shown in Video)in one Legal Paper?
yes
@@shahabislam4912
Dear Sir,
Heartily Thank you for kind reply and Valuable.
I will try to make it one legal Paper
is there any issue then I will keep issue over here
Kind Regard,
Basavaraj
@@shahabislam4912 sir i need your help ? How should i contact with you.
Nice sir
sir clothes sales reports bataye ek video plz
i will upload as soon
Hello sir canteen stock items kaise Entry karte Hain .or kaise issue karte Hain .kripya bataye sir .I am Ronit Kumar from Gujarat India . thank you sir
ruclips.net/video/q6VPCX8QW9Q/видео.html
ruclips.net/video/aGlwx6Pk4aw/видео.html
ruclips.net/video/aokiP9Nw-00/видео.html
How to repeat IF formula in same cell many times for getting different logical values for different criteria. Or simply how to use IF formula many times in same cell. Plz help.....
باقی تو ٹھیک ہے لیکن Sun رو میں ہائی لائٹ نہیں ہوتا کیوں؟
absolute krna parta he hojega
i like this
Sir plz tell me ki month change karne pr data hatta kyu nhi he ohi rahta he agar dusra month select kare to data new entry hona chahiye o kaise kare
This is normal calculations, please make advance label attendance sheet
A. O.A
Sir total working days find krny ka kia formula h plzzzzz bta dy
ruclips.net/video/g3lLSJYI40k/видео.html
ruclips.net/video/pIYDaD9AVbM/видео.html
Digital Attendance Devices কিভাবে এক্সেল শীটে ব্যবহার করা যায় ?
Dear Sir How to select spread sheet border margin. I make a spread sheet then some mistake on top and some border bottom please reply
Aww
Usko 1 a4 page me kis tarah karsakata hu??
Me ne jab print kia to 3 page me nikla
CHECK LINK THANKS FOR COMMENT
ruclips.net/video/gtAlTqNG7QE/видео.html
fine,but new formula rule comment not clear seeing
Can you please tell me if half days available in the attendance sheet . So how to calculate the total working days because we have to deduct the half days from total working days.....Please reply soon or upload related video.....
I THINK YOU ARE ASKING ABOUT TIMING CARD. THE VIDEO I WILL UPLOAD AS SOON AS POSSIBLE.
yup Right ..i m waiting for related video & Thanks for reply....
SIR M USING....EXCEL 2016
this sheet you can use in all excel version.
Sir muje ekhi sheet me 12 month ka chahiye possible he kya he to plz muje o video Ka link dena na
So plz help me ki o month change kiya to full format change kaise kare
iski video bhi bnata ho jaldi thank's For Comment
wel
A. O. A
Sir mj sy sun wla formula ni h ra plzz bta dy
Ye File Download karlen. Formula isme dekhlen kese lagega.
drive.google.com/open?id=1IfD_stGN7UkUKDxW0a-cvS5D1m6Cqt1I
How to make attendance percentage
ruclips.net/video/LjAPxn93n4U/видео.html
i am not able to type the conditional format formula, mean for highlighting Sunday's, please type and send me that formula
how we can print out this sheet please guide
1-ruclips.net/video/gtAlTqNG7QE/видео.html
2-ruclips.net/video/isYw1yq68yQ/видео.html
what about halfdays
good video any one cant do that
sir how to prnt this fileas sme you made it? on portrait or landscape ??? tell me plz
Cehck Link print & page setup
ruclips.net/video/gtAlTqNG7QE/видео.html
dear sir,
=text(D4,"ddd") i got the correct day but im not able to fill the other cells with the copy feature,
it is giving the same day to all cells.
frst mention date nd drag it....then set day formula nd drag it too....after doing this days will not b the same........
day will be
automatically set according to date...
sir i have write date like this ....19-1-18.....according to this how can i write day formula....of =TEXT(C2,"DDD")......?
No this format is not in excel, you can use only this format 1-jan-18 or other format you can check in number format.
and any thing want to know about excel please comment.
ok sir i got it...nd than q for guiding us in such a gud way
Sir when colour Sunday due to formula it's not shows plz write down in comments
ap video ke step complete dekhen or phir try karen.
My sunday is not working
Ye sheet send kar dyn plz
Sir
Isi tarah aur se month ka banana hai to kaise karen
aesi hi bnaege
Sir tode bde sheet bnayo dikaye nhi dete
acha. ap hd Quality select karke Watch karen. phir baten.
તમે વિડિયો ઝૂમ કરીને બતાવો તેથી અમે ઉપરનાં મેનુબાર તેમજ ફોર્મમૂલા વિગતે સમજી શકી.
Sir agar ese ek page print karna ho to kaise karenge
check this link and leave comment
ruclips.net/video/gtAlTqNG7QE/видео.html
ME HACI KAR RAHE HO BUT NHI HO REHA
=OrText($B$3,"DDD") ="SAT",text($B$3,"DDD")="SUN" Hi..am having a problem with this fourmula..to highlight Saturdays and sundays..can you please help me
अस्सलाम वालेकुम रहमतुल्लाह बरकातहू मेरे को मोबाइल में बनानि है कैसे बनाये
walekum salam. Mob Application Thir alag hen. me is pe video bnuga inshallah jaldi.
Kuch bhi words clear nahi dikhre sir ..clear bataye
sir g percentage kesy nikalty hn
Please Watch This Video & Leave a Comment
ruclips.net/video/LjAPxn93n4U/видео.html
Seriously kuch nahi dikh rha sir
Assalam o Alaikum. Shahab Islam bhai aap ki attendance sheet wali videio bohot achi lagi. bus itna bata dain kay total present walay column may agar hum sunday ko bhi include kerain to kesa hoga. please ismael.cttc@gmail.com per zara tafseel say email kerdijiye ga. ALLAH JAZA E KHAIR day aap ko
W.salam
CountA Ka Formula Lagega All Range Select OR enter
Can’t understand what you’re saying
uncle its less than basic. Grow-up plz
Very bad
Thank you so much
You're most welcome
Good
Sir when colour Sunday due to formula it's not shows plz write down in comments