If I understand correctly your attendance policy dictates that WO can not be taken between two absents and if one is absent on either side of a WO he will be marked abset fort that WO too.
If so please find attached an excel sheet with a macro that will tabulate the same for you.
all you need to do is enter the data in the format and click on the button on the top left corner.
3rd November 2013 From India, Mumbai
You should take a look at some automated leave and attendance management system which can be extended with ESS so your manual work is reduced and the process is also transparent.
Our company and many others provide such solutions. I'll be happy to provide more details on this if you wish.
4th November 2013 From India, Chennai