View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 1st Monday of a month in date range??


scwilly:

Possibly my last question...

In the example scenario:

StartDate: 1/21/2006
EndDate: 4/19/2006
Occurrences: 4
WeekDay: TUE

You indicated that there would be four 4th-Tuesdays.

I'm guessing that those four 4th-Tuesdays would be:
Jan_24th
Feg_28th
Mar_28th
Apr_25th

If that's true, do you mean that we should use the entire month of the
StartDate and entire month of the EndDate?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=535648