Stylish Attendance Tracker with Symbols in Excel

[@MrSoy007]

Thank you PK, have learned a lot by watching your videos

[@PKAnExcelExpert]

Most welcome🙏

[@nsanch0181]

That was some heavy formatting. Thank you PK. I'm glad I went through that lesson. I feel like I learned conditional formatting a lot better. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@srinivasvayuvegula4630]

excellent explanation. Any lay man can understand. Once again very very great.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@johnfebrero6859]

Thank you! Just got my new monitoring sheet.

[@PKAnExcelExpert]

Glad I could help!

[@azimuddin9936]

You are genius sir thank you for teaching us . Make us god of excel.❤️❤️

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ransomchidi3786]

Thank you for making out time to put together this clip. I have tried to do the conditional formating for the webbing text but it keeps showing the wrong symbol. What can i do??

[@صقر_الجزيرة]

Awesome work, i have one question for you. How can I have the marked days with symbols moves along when we change the month period. in other word, if I changed the month period the attendance sheet in the schedule also follow it the change period. for example, if X person attended on 1st. Jan but did not attend on 1st Feb then when i change the month above I want to have the attendance also be changed with the change of month so I can meet my exact match of the attendance. ♥

[@kishorpanara4191]

You are excel magician

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@khanhtranman1774]

thanks very much! It is useful

[@PKAnExcelExpert]

Glad it was helpful!

[@KhalilAhmad74036]

Once more with an interactive video, Thanks, and appreciated your efforts!

[@rajkgpt.01]

You are genius sir🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nnbona]

very useful file I do like it so much PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SahilSahil-vo1yw]

Awesome!! It's really helpful for me as well. Thank you so much for this video. Good Job!! Much appreciated!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mirrorreflection3479]

Can you check if the practice file format is correct ? It's downloading as txt file.

[@coding3800]

Hi Bro .Thank you for incridible video . I am from Uzbekistan . I am having problem with formula it cant type (=text ) this formula doesnt work what can I do ?

[@bhalchandragodse4514]

Can you make a video on 3 × 8 hour weekly Shift planner for 30 days with alternating week shifts with changing week off after every week to preceding day??

[@Debbiexue99]

thanks alot :P

[@PKAnExcelExpert]

Welcome

[@SD-bq5uk]

If u change any month the previous month data is not saved.. it ll display for every month same..say if i mark March 1st as present..nd change April month ...data for March 1st is still appears.. were it supposed to be new sheet for april

[@mustafeosman1]

Thanks.

[@PKAnExcelExpert]

Welcome

[@zahirbabar8055]

What about the public holidays in the setting sheet?

[@ajinkyanaik6651]

Dear Sir, Please upload such more video

[@PKAnExcelExpert]

I will try my best

[@nullhas]

Sir Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..

[@rash9366]

Nice..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@flightofdreams-s8f]

how do i add half days in this sheet please explain

[@azimuddin9936]

Plz make one video for software office administrator work in Excel. All in one vid 🙏🙏plz

[@ashannavemula4134]

Hi sir please explain how to rotate each shift as 10 to 17 staff roster approximate 3 shift

[@mirrrvelll5164]

Amazing man! Will to do by myself and use it later =)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Danisdx]

How to do background color .. that blue color

[@sureshkumarpantla]

conditional formating custom rule not working, it shows only 'a' instead of symbol. please tell me anything else to do

[@sureshkumarpantla]

ok now its working thank you

[@innerpeacefindings1046]

Dear PK ,IF ATTENDANCE MENTIONED 21st TO 20th of month then...if make a vedio if possible 😊

[@munawarnazir163]

Sir 24 hour attendance for Petrol Pump shift

[@johndas8173]

Hindi me banoa sir apke subscriber aur jyada badh jayenge