Thank you in advance for ANY help! I need to create a list of dates from 2006 thru 2013 in column A, then to have the paydate in column B. Obviously, doing this manually would take forever! I already have the dates listed in Column A, just need to figure out a formula to calculate the pay date...