I would like to determine the next date that has a day of the week value equal to something I specify.
For example, today is 6/21/2010 and the day of week value is 1 b/c today is a Monday. How do I find the next date with let's say a day of week value of 3.
I would like to consider all cases that come close to the end of something including month and year.
Is there any easy way to do this or do I have to manually check to see if it's close to the end of the month or year and make adjustments accordingly? I feel there is an easily and better solution than doing that.