So, somehow, you entered a formula in the top cell of a range and then dragged the content of that cell down to numerous rows below it and the dates filled in those cells but this did not include weekends. Is that right? To reiterate, you did not simply enter the date in the first/top cell, you entered a formula which skipped Saturdays and Sundays. Am I right so far?