In A1:A12, enter the first day of each month.
In B1:
=A1-WEEKDAY(A1)+11+(WEEKDAY(A1)4)*7
In C1:
=B1+14
Copy B1 and C1 down to the end of the list.
Tim C
"lawdoggy" wrote in message
oups.com...
Hello,
I need to figure out all the 2nd and 4th wednesdays for all year long.
These days are set and are used for the same purpose (training) so I
would like to be able to print a list instead of hunting down a
calendar and counting. Any help would be greatly appreciated!
Thank you.....mitch
|