Is there a way to create a Data Validation dropdown list of the next 52 Fridays?

[USAMax]

We have weekend projects that start on Fridays and I know I can create a list on a separate worksheet but I would like to avoid this.

I think I need a Data Validation formula using WEEKDAY in it.

Thanks,

 

[BrianMH]

You can validate that it is a friday using just a formula but I don't think you can get an array of the next 52 fridays.

 

[USAMax]

Thank you, that is what I assumed but you just never know.