Good day guys, I need your help in my attendance log to scan all start date and end date and result the absent date
example
Name--------------Start date-----------------End date
John---------------june 1 2014---------------june 15 2014
John---------------june 17 2014--------------june 30 2014
edward------------june 1 2014--------------june 7 2014
edward------------june 10 2014-------------june 30 2014
Result
John absent - ----June 16 2014
edward absent - ---- June 8 2014 and june 9 2014
I have a thousand data and its hard to do it manually. I attach the sample - hope someone can help me
Thanks for your help..
Bookmarks