What date is Next Thursday

[chuckster]

I the a function or some code out there that can tell me what date the next thursday from now() is.

Cheers

 

[SteveA]

The following function will find the next Thursday after today. This function will always find the next Thursday after today (no matter what today is: Monday, Wednesday etc)

=DateAdd("d",12 -WeekDay(Date()),Date())

If you are wanting a date that is 7 days from now, you could enter:

=DateAdd("d",7,Date())

HTH
SteveA

 

[chuckster]

Thanks M8.

The function seemed to work beautifully on Friday the 19th of October.

It assigned the correct date of Thursday the 25th of October. On Monday the 22nd however it now jumps to Thursday week, which is the 1st of November. Dateadd adds 10 days instead of 3. I want the very next thursday from current date if possible.


Any ideas

[This message has been edited by chuckster (edited 10-21-2001).]

 

[SteveA]

Hopefully this should do it:

=IIf(WeekDay(Date())>=5, DateAdd("d",12-Weekday(Date()),Date()), DateAdd("d",5-Weekday(Date()),Date()))

HTH
SteveA

 

[chuckster]

Thanks. I got impatient and wrote a function to dateadd a day then compare the day name to that of one selected from a combo box. If they don't match it adds another day etc.

Thanks again for you help.

Luke