G
Guest
This is what I have so far...
=Format(DateAdd("d",7-Weekday(Date(),6),Date()+7),"mm/dd/yy")
What I need is for it to calculate the next thursdays date. So if today was
Wed then I would need the date for the next day. If today was Thur then I
would need the date for next Thur.
The above calculation gives me the date for Thur but 2 weeks in the future.
=Format(DateAdd("d",7-Weekday(Date(),6),Date()+7),"mm/dd/yy")
What I need is for it to calculate the next thursdays date. So if today was
Wed then I would need the date for the next day. If today was Thur then I
would need the date for next Thur.
The above calculation gives me the date for Thur but 2 weeks in the future.