0

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.

1
  • Third Monday, or third Monday after the entered date? (I.e. what if the date entered is after the third Monday? Mar 19, 2019 at 16:02

1 Answer 1

0

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

1
  • Thank you for your response! I have tried this and it is resulting as "1". Where am I going wrong?
    – Ronnie
    Mar 19, 2019 at 16:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.