Find 1st friday after a varible date

  • Thread starter Thread starter GitarJake
  • Start date Start date
DatePart("w", varDateVariable, vbSaturday) returns a number corresponding to
the day of the week. By specifying vbSaturday as the 3rd argument, it will
return 1 for Saturdays, 2 for Sundays, 3 for Mondays and so on up to 7 for
Fridays.

By subtracting that value from 7, therefore, you know how many days it is
until the next Friday, so you add that many days to your date.
 
Hi Again Ken,

This works great! Do you mind explaining it to me a little?

Thanks again,

Jake
 
Back
Top