Hello all!
I need help in writing a code that will calculate the dates of referenda based on the Year and the Month. This would be fine, except on each of the five months that referenda are held, the day differs. Here's what I mean:
on January, referenda are held on the 4th Tuesday of the month; March, 2nd Tuesday; April, 3rd Tuesday; September, the last Tuesday; and on December, the 2nd Tuesday. I have the dates set up in an option group, to allow the user to pick a month, then I have unbound text boxes alongside to show the date. Only the date will be stored.
This idea was taken from an Excel spreadsheet, which provides us with a lot of the information, and isn't yet linked (currently, outside users are filling in the spreadsheet and e-mailing the information to us, which then has to be manually inputted), but I know the code will be much different. Can anyone help me? Thanks!
I need help in writing a code that will calculate the dates of referenda based on the Year and the Month. This would be fine, except on each of the five months that referenda are held, the day differs. Here's what I mean:
on January, referenda are held on the 4th Tuesday of the month; March, 2nd Tuesday; April, 3rd Tuesday; September, the last Tuesday; and on December, the 2nd Tuesday. I have the dates set up in an option group, to allow the user to pick a month, then I have unbound text boxes alongside to show the date. Only the date will be stored.
This idea was taken from an Excel spreadsheet, which provides us with a lot of the information, and isn't yet linked (currently, outside users are filling in the spreadsheet and e-mailing the information to us, which then has to be manually inputted), but I know the code will be much different. Can anyone help me? Thanks!
