Recurring date formula

  • Thread starter Thread starter Mc/
  • Start date Start date
M

Mc/

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))
 
=DATE(YEAR(A1),MONTH(A1)+1,22)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,4))

I did dome tinkering and was able to reduce that to:

=A1+28+((DAY(A1+35)<22)*7)
 
I have a similar question. I tried Formulas and got #VALUE! in A2 I did a
copy paste to be sure I didn't 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.
 
Back
Top