J
JT
Users enter a date in a specific cell on a specific sheet. Users can only
submit items for the previous month if it is the first or second weekday in
the current month.
If the date is for a previous month, I want my macro to look at the current
date and figure out if it is the third weekday in the current month or later.
During this process, I need to skip Saturdays and Sundays.
For example:
February 2009:
Day 1 = Monday 2/2
Day 2 = Tuesday 2/3
Day 3 = Wednesday 2/4
If the user enters a date of 1/31 and submits it on 2/2 or 2/3, it is okay.
However, if it is 2/4, it's not okay.
I'm not sure how to get started to figure out which day of the month the
current date.
I'm also looking for suggestions on how to add company holidays into this
edit.
Thanks for the help.....
submit items for the previous month if it is the first or second weekday in
the current month.
If the date is for a previous month, I want my macro to look at the current
date and figure out if it is the third weekday in the current month or later.
During this process, I need to skip Saturdays and Sundays.
For example:
February 2009:
Day 1 = Monday 2/2
Day 2 = Tuesday 2/3
Day 3 = Wednesday 2/4
If the user enters a date of 1/31 and submits it on 2/2 or 2/3, it is okay.
However, if it is 2/4, it's not okay.
I'm not sure how to get started to figure out which day of the month the
current date.
I'm also looking for suggestions on how to add company holidays into this
edit.
Thanks for the help.....