How To Create Fully Automated Attendance Sheet in Excel | Change the Month, & Days Automatically
Vložit
- čas přidán 12. 09. 2024
- #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."
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 ?
I really like the way you teach
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.
Kindly help me too to create an automated attendance
How to change year
I mean automatically change the next year when finish the previous year
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.
Yes we can make the one.....give me sometime....I will revert back to you
You're creating for one month.. but the data will not be saved and auto delete for the next month..
do you know how to solve this please
gone through couple of video using same technique but basic question is how does the data will change when month and year changes no body is telling that
@@ayushmann_dwivedi yes, even I have the same doubt, but no is showing proper solution to that
When we prepare multiple sheets why there is a need to use multiple formulas, you can directly put in it right. Show us how the data changes when the month is changed in single sheet
WhatsApp line