First of all, Thanks everyone for your comments and valuable time. The above link in the previous reply gives a clear picture of how the 180 days will be calculated. If I re-calculate based on that, I end up with the following table, Currently ONLY WHOLE DAYS absence is considered and not the depar...