Date Formula

[mszypa50]

Hello,

I am looking for a formula where I can find all the 2nd Mondays of a given year for a generator schedule. Your help is appreciated.

[Richard Buttrey]

Do you mean the 2nd Monday of each month?

[Jdevil]

Or do you mean 1/2 mondays? Like Monday # {2,4,6,8...}

You can find first monday of a year with this:
=DATE(2015,1,8)-WEEKDAY(DATE(2015,1,6))
If that's the case I described, then you could find the second by doing +7, then the others by doing +14.

[newdoverman]

If you enter the year in A1 enter this in A2 to get the 2nd Monday of the year.

Please Login or Register  to view this content.

For every 2nd Monday after that, enter this in A3 and fill down:

Please Login or Register  to view this content.

If you want every 2nd Monday from a given date entered in A1

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

[mszypa50]

Every 2nd Monday of the Month for the whole given year

[Jdevil]

Assuming you have a starting date (such as TODAY()) in D1, and that you have 2 columns:

Column A has the values 0,1,2,3,4,5,6... (A1 = 0, A2 = 1, A3= 2, etc) for as long as you need
In column B, use this formula: (put it in B1 and drag it down)

=DATE(YEAR($D$1),MONTH($D$1)+A1,1)+CHOOSE(WEEKDAY(DATE(YEAR($D$1),MONTH($D$1)+A1,1)),1,0,6,5,4,3,2)+7

[mszypa50]

Assuming you have a starting date (such as TODAY()) in D1, and that you have 2 columns:

Column A has the values 0,1,2,3,4,5,6... (A1 = 0, A2 = 1, A3= 2, etc) for as long as you need
In column B, use this formula: (put it in B1 and drag it down)

=DATE(YEAR($D$1),MONTH($D$1)+A1,1)+CHOOSE(WEEKDAY(DATE(YEAR($D$1),MONTH($D$1)+A1,1)),1,0,6,5,4,3,2)+7

Thank you. Works fine