SirJB7,
That worked great! Building on this is there a way to populate the remaining payperiod dates for the balance of the year? Essentially auto loading the following paydate? (e.g. - if the initial computation was for 01/15/2012 can I automatically populate subsequent cells for...
I am writing a spreadsheet with a semimonthly formula to identify a payperiod based vacation accrual . . . and I can't figure out the formula. The company pays on the 15th day and the last day of each month; and it hires employees throughout the year. This mean that I need to be able to use...