Options

Date Formula

HI,
Is there any simple code to get the 3rd Monday of the month?

Answers

  • Options
    Developer101Developer101 Member Posts: 528
    edited 2021-05-23
    Simplest formula would be CALCDATE('WD1+2W',Date)

    For example: CALCDATE(''WD1+2W',01052021D) would return 17/05/2021 which first day of the week.
    United Kingdom
Sign In or Register to comment.