Why don't you just use the formula Today() in your Sheet1, for example, in A1, and use formula A2= A1+1 and drag down till A21. That will give you a list of the 21 dates including today.