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.
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.
Do you mean the 2nd Monday of each month?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Every 2nd Monday of the Month for the whole given year
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.
If you enter the year in A1 enter this in A2 to get the 2nd Monday of the year.
Formula:=DATE(A1,1,1)-WEEKDAY(DATE(A1,1,1)-2)+14
For every 2nd Monday after that, enter this in A3 and fill down:
Formula:=A2+14
If you want every 2nd Monday from a given date entered in A1
Formula:=DATE(YEAR(A1),MONTH(A1),DAY(A1))-WEEKDAY(DATE(YEAR(A1),MONTH(A1),DAY(A1))-2)+14
Then
Formula:=A2+14
Last edited by newdoverman; 08-10-2015 at 05:07 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks