quite difficult to do in excel because of how excel lack features/functions that involves manipulation/calculations based on dates...not impossible but will be quite complicated. i tried and it ain't pretty...