How To Create Fully Automated Attendance Sheet in Excel | Change the Month, & Days Automatically

#AttendanceSheet
#AttendanceRegister
#Excel
#StaffAttendanceRegister
#AttendanceTracker
#ExcelTutorial
#LearnExcel
#Excel_Formulas_and_Functions
#Excel_online_course
#deepakeduworld​​
#Microsoft_Excel
#How_To
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Copyright © 2020 Orchids eLearning. All rights reserved.
Any illegal reproduction of the content from this channel, in any form, will result in immediate action against the person concerned."

[@hemusingh8448]

If we are writing P or A in a cell and then changes the month, the cell containing data will remain same.
Like we are writing P on 6th of April 22 and then changes the month to May, the Cell containing P remain the same but the date will be shifted according to the month selected. The same student can be Absent on the same date of next month.
Plz clarify how to solve this problem ?

[@qverel]

I really like the way you teach

[@dawitamoheau6703]

I can't seem to apply the holiday error alert through data validation.
It's not showing the error alert why I type the P on Sunday column.

[@musondapeter3441]

Kindly help me too to create an automated attendance

[@sanaulhaque4674]

How to change year
I mean automatically change the next year when finish the previous year

[@rinrovin6054]

Hello. Is there a formula that can make a total number of person per day(at the end of the number of person per day) will become blank, if it falls saturday, sunday, or holiday or breaks, or no class?
Additional information Sir, if it falls on the day that is not a holiday, sunday, or saturday, the result is the number of persons present on that day.

[@orchidselearning12]

Yes we can make the one.....give me sometime....I will revert back to you

[@jenny1234541]

You're creating for one month.. but the data will not be saved and auto delete for the next month..

[@filiproh2625]

do you know how to solve this please

[@musondapeter3441]

WhatsApp line