How to calculate the third Monday of the month an item is created using a calculated column (date / time)?
I wish to calculate the date based on the created column.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
This should do what you need:
=DATE( YEAR(SomeDate),MONTH(SomeDate),1 ) + 2 - WEEKDAY( DATE( YEAR(SomeDate),MONTH(SomeDate),1 ) ) + 14 + IF( WEEKDAY( DATE( YEAR(SomeDate),MONTH(SomeDate),1 ) ) > 2, 7, 0)
The "2" is for Monday. (twice in the formula)
The 14 is for the third week - 0 for 1st week, 7 for second week, etc.
I.e. (weekNumber - 1 ) * 7