Attendance to identify the absent date

Hi junbone,
Welcome to the Forum.

If you are open to a VBA solution to achieve this, try this.....

Please Login or Register  to view this content.

You can change the range reference codes in red as per your actual workbook.

To apply this code to workbook follow these steps.

1. Open your workbook
2. Press Alt+F11 to open VBA Editor
3. Click on Insert --> Module
4. Paste the above code in opened code window.
5. Close VBA Editor
6. Save your workbook as Excel Macro-Enabled Workbook
7. To Run the code, Press Alt+F8 to open Macro Window.
8. Select Attendance macro from the macro list
9. Run

Please find the attached sheet and click on the Green Button to get the desired output.

Hi Junbone..

Formula:

Please Login or Register  to view this content.

Drag down and horizontally...
Check the attached file...

If you are not familiar with VBA, in that case you should go with the formula suggested by Vikas. Because to change the code as per your requirement requires some basic understanding of VBA.

Thanks Sktneer for reputation point..
This really means a lot..


Regards,

@junbone
Thanks. If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.