How do I count the order of Weekdays in a month?
I need to automate first, second, third, etc. Sunday, Monday Tuesday, etc in each month. I can't use the Week() function since it counts weeks for the entire year.
Week([Surgery Date]) - Week(DateAdd("dd",(-DayOfMonth([Surgery Date])) + 1,[Surgery Date])) + 1
The above doesn't give information by the weekday but by the week. Anyone have ideas for my problem?