jaguar5554

asked on

# Excel formula to define date as X day of month (e.g. First Monday, Third Wednesday, etc.)

Hello, is there formula (Excel) or expression (Access) that defines a date as the first or second or third or fourth weekday of the month? For example, if in Excel A2 = 1/1/2013, the formula returns "First Tuesday" or if A10 = 1/9/2013, the formula returns "Second Wednesday", etc. Any help or feedback is much appreciated! Thank you.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

Glad to help. Thanks for the kind words.

Thomas

Thomas

ASKER