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
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
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
- Battle without fear gives no glory - Just try
Thank you very much!
how to close my post?
"how to close my post? " see forum's rules at the bottom
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)
Audere est facere
Thank you DDL for the adjustment
PCI
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks