Getting the Date of the nth Weekday in Every Month

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Morgan (david_at_davidmorgan.me.uk)
Date: 02/24/04

Next message: Aaron Bertrand [MVP]: "Re: but but but..."
Previous message: M P: "Re: CDONTS not working using other SMTP Server"
Next in thread: Manohar Kamath [MVP]: "Re: Getting the Date of the nth Weekday in Every Month"
Reply: Manohar Kamath [MVP]: "Re: Getting the Date of the nth Weekday in Every Month"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 24 Feb 2004 01:35:52 -0000

Hopefully the subject says it all. Given a weekday, (1 to 7) and an
occurrence with in a month, (1 to 4), I need to ascertain the date on which
it first occurs in any given month and year.

For example, what is the date of the third Tuesday in October 2004.

Has anyone done this before? Would be grateful for some assistance.

Regards

David

Next message: Aaron Bertrand [MVP]: "Re: but but but..."
Previous message: M P: "Re: CDONTS not working using other SMTP Server"
Next in thread: Manohar Kamath [MVP]: "Re: Getting the Date of the nth Weekday in Every Month"
Reply: Manohar Kamath [MVP]: "Re: Getting the Date of the nth Weekday in Every Month"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Outlook Web Access / Remote Web Workplace
... Thank you both for your assistance. ... I am unable to however ascertain ... the appropriate steps to correct this from either of your respones. ... Mikael: Do you have any other information on FQDN? ...
(microsoft.public.windows.server.sbs)
DatedIf worksheet function to calculate %
... I have a scenario where I want to calculate the difference between two dates in order to ascertain the % time elapsed from the current date against the start date. ... Can anyone provide any assistance? ... TIA Vers ...
(microsoft.public.excel.worksheet.functions)
Re: Dont be a Hacker
... multiple definitions; and best to ascertain which is ...
(alt.lang.asm)