Calculating next date of Service

[Answers]

Calculate Repeating Service Dates

I'm sure I'm just missing a small piece. I need to calculate the next date of service based on the frequency code. So if the code is AN (for annual) I need the calculation to be the date plus a year BUT I always need it to be the same day of the week. For example today is Thursday April 9th, the second Thursday of the month of April. I need the next service to be scheduled for the second Thursday of April in a year. The second thursday of April in 2010 is April 8, 2010.

I need this to work for Monthly, quarterly etc. So always the same day of the week of the month. I know how to get Day of Week.

any help is greatly appreciated!

Caroline

[RalphL]

Look at the custom function DateByDayOccur ( yearNum ; monthNum ; dayOfWeekNum ; dayOccurance ) on Brian Dunning's Custom function web site.