How can I create a formula which will results in setting recurring dates when copied down a column. I want the date to be on the 3rd Wednesday of each month. Each row would be for a successive month. This is essentially like the process available in Outlook for scheduling appointments, set the recurring criteria and it calculates the specific dates.
Enter the first date in a cell: A1 = 1/21/2009 = 3rd Wed in Jan 2009 Enter this formula in A2 and copy down as needed: =DATE(YEAR(A1),MONTH(A1)+1,22)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,4)) -- Biff Microsoft Excel MVP
I did dome tinkering and was able to reduce that to: =A1+28+((DAY(A1+35)<22)*7) -- Biff Microsoft Excel MVP
I have a similar question. I tried Formulas and got #VALUE! in A2 I did a copy paste to be sure I did not have syntax errors and the same thing. What I want mine to do is list every Sunday beginning on November 25, 2009
November 25, 2009 is not a Sunday, but you could enter this and copy down as needed: ="25-Nov-2009"-WEEKDAY("25-Nov-2009")+8+(ROW(A1)-1)*7 Don't forget to format the cells as date.