Find 1st friday after a varible date

[GitarJake]

Hello all,

How do you find the 1st Friday after a variable date?

TIA,

Jake

 

[Ken Snell]

DateAdd("d", 7 - DatePart("w", varDateVariable, vbSaturday),
varDateVariable)

 

[Douglas J. Steele]

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.

 

[GitarJake]

Hi Again Ken,

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

Thanks again,

Jake