rivet Posted November 11, 2003 Posted November 11, 2003 I am trying to figure out if a date is the first Thursday of the month. I was thinking of comparing the week of the first day of the month to the week of the RunDate (always on a Thursday) if they match, then 1. Unfortunately 11/7/2002 proved me wrong, I is the first Thursday of the month but it is in the second week.. If(WeekofYear(Date(Month(RunDate), 1, Year(RunDate)))=WeekofYear(RunDate), 1, "")
Recommended Posts
This topic is 8068 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now