Since June is coming up fast you should probably figure out what you are going to do.
A typical 100 watt solar panel weighs about 15 pounds and runs $100 on sale. A typical 50Amp Hour AGM style battery (25 Amp Hours usable) weighs about 30 pounds and costs about $110. A 12 volt automotive fan costs about $17.00 - $25.00 and weighs a couple of pounds. So on a good day you are looking at 45 pounds of gear and $235.00 for a reliable solar solution for running a fan all night indefinitely. And then you still have to figure out how to get the panel to the campsite without breaking it.
Or you can buy an an O2 cool fan for $17.00 that weighs 2.5 pounds and a couple of sets of D Size batteries for $1.20 and 0.36 pounds each. How many batteries are needed? That is going to depend on the actual fan that you buy. Some are more energy efficient than others. I haven't used this fan but people that have say that you can run it for 3-4 nights on low with one set of Energizers. So without trying the fan before hand then would recommend that you take three sets of batteries. 7 pounds and $21.60. You could probably get by with two sets though. Me? I would buy four sets and leave two sets in the car. Then if I needed them I could hike back and get them.
Now this fan does have a cigarette lighter adapter available. I have run a similar fan overnight from an automotive jump pack. The irony is that they typical Jump pack has a 20-25 Amp Hour battery in it. Which to protect the battery, you cannot draw more than 10-12 Amp Hours from it. That is the same amount of Amp Hours (at 1/6 the weight (18 pounds vs 2 pounds) and 1/19 the cost ($133 vs $7) that you can expect to get from one set of D cell batteries which you can run dead.
Or you could buy a 12 Volt AGM battery and equip it with a cigarette adapter. But you are still dealing with the extra weight of Amp Hours that you cannot use without damaging the battery. Remember that draining AGM's beyond 50% reduces their life significantly. And I am thinking that LifePO4 batteries are out of your price range.
So despite the fact that it isn't "cool" (no pun intended) the solutions that people are recommending OVER AND OVER is the most cost effective, weight efficient, reliable, and shortest learning curve method of using a fan to stay cool for short periods of time off the grid.
Keep in mind that these are general numbers and you might be able to get these solutions done cheaper. But they might be more expensive. I used current Amazon prices for the specific parts that I looked up.
So if I were you , I would get the fan and run it on D batteries for this year, and throughout next year play with different ways to power it. Then when you go camping NEXT year you will have built up some experience on what works and what doesn't for wind/solar and whatnot.
https://www.amazon.com/O2COOL-10-Inch-Portable-Desktop-Circulation/dp/B013BOC6VC/ref=sr_1_4?dchild=1&keywords=02+cool+fan&qid=1619955422&sr=8-4As always YMMV.