Forum Discussion

franklad's avatar
franklad
Copper Contributor
Jun 28, 2019

does excel have a formula to calculate the return the day number for a condition such as the 1st Mon

hi

I'm trying to get the day number (1-31,etc) on a spreadsheet corresponding to the third Wednesday in a particular month. Is this possible or do I just do it manually?

excel

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 28, 2019
    Try this:
    =DAY(DATE(Year,Month,22)-
    WEEKDAY(DATE(Year,Month,1)-4))
  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jun 28, 2019

    Hello franklad,

     

     Use this formula:

    =DATE(y,m,22)-WEEKDAY(DATE(y,m,4))

     

    Fill in y with the year and m with the month and format the cell as Custom Type: dd

     

    Hope this helps!

    PReagan