VBA to return the date of the Friday after a given date
Posted by RichT on January 23, 2002 12:59 PM
I've been searching the old posts for clues to this solution with no luck...
I have rows of sales information with sale date in the first column. How can I use VBA to take a date (say 1/2/02), and determine that the date of the Friday of that week would be 1/4/02? The raw and converted dates would look like...
Mon 12/31/01 -> 1/4/02
Tue 1/1/02 -> 1/4/02
Wed 1/2/02 -> 1/4/02
Thur 1/3/02 -> 1/4/02
Fri 1/4/02 -> 1/4/02
Thanks in advance for your suggestions