Link to home
Create AccountLog in
Avatar of jaguar5554
jaguar5554Flag for United States of America

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.
Avatar of nutsch
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jaguar5554


Thomas, you are a genius -- that is exactly what I needed. Thank you so much.
Glad to help. Thanks for the kind words.