I was looking in internet, but the formulas look so complicated. Any clever suggestions?

/i.e for example I need a formula that identify which date is the first Monday in August 2014, similar to be used- for the second Monday, etc/

Thank you

# Excel – How to identify first , second etc Monday or other day of week for a given month in excel

excel

## Best Solution

Generically, you can find the

n-th of anxday of a givenMandYwith this formula`=DATE(Y,M,(n*7)+1)-WEEKDAY(DATE(Y,M,8-x), 2)`

where x is a number representing the day of the week from 1 = Sunday through to 7 = Saturday

So from that

1stMondayinAugust2014is found by this formula`=DATE(2014,8,(1*7)+1)-WEEKDAY(DATE(2014,8,(8-1)), 2)`

If you want the

lastMonday in any given month you can find the first Monday of the next month and subtract 7See my article here for more