Current weeks Friday

[oxicottin]

Hello, I need to have my forms textbox to have the current weeks Fridays date as a default value. In my formula what am I missing it gives me #Name?.

=DateAdd("d", 8 - Weekday(Date(), vbFriday), Date())

 

[pbaldy]

You can't use a VBA constant in a form. Try 6 there.

 

[Pat Hartman]

NextFriday = YourDate +7 - weekday(YourDate)- 1

 

[oxicottin]

That works thanks...