# Generate the date of the second in each month

1. ## Generate the date of the second in each month

Hello everyone,

I would like some assitans in developing a script or a using standard forumlas in Excel which can help me generate the date (YYYYMMDD) of the second Monday in each month.

Someone who has an idea?

Regards,
Mikael

2. ## Re: Generate the date of the second in each month

Let assume B3 = a date
Somewhere =DATE(YEAR(B3),MONTH(B3),1)-WEEKDAY(DATE(YEAR(B3),MONTH(B3),1),2)+15
gives the date of the second Monday of the month for the selected date

3. ## Re: Generate the date of the second in each month

Thank you very much!

4. ## Re: Generate the date of the second in each month

how to close my post?

5. ## Re: Generate the date of the second in each month

"how to close my post? " see forum's rules at the bottom

6. ## Re: Generate the date of the second in each month

Originally Posted by PCI
=DATE(YEAR(B3),MONTH(B3),1)-WEEKDAY(DATE(YEAR(B3),MONTH(B3),1),2)+15
This formula always gives a date in the range 9th - 15th but for 2nd instance it needs to be 8th - 14th otherwise when the month starts on a Monday you get the wrong result, e.g. in June 2015 second Monday is on the 8th not 15th. To get correct results in all cases you can use this formula

=B3-DAY(B3)+15-WEEKDAY(B3-DAY(B3)+6)

7. ## Re: Generate the date of the second in each month

Thank you DDL for the adjustment
PCI

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1