Last time, we discussed about finding Labor Day in a given year. This time, it is is about Thanksgiving Day in a year. Thanksgiving day is 4th Thursday in a November.
Hence, earliest possible day when 4th Thursday can happen is on 22-Nov.
Now, let's utilize the knowledge gained in Article 34 – Show Date for a Coming or Previous Day (Say Coming Monday, Previous Friday)
The formula would be
=CEILING(DATE(A1,11,22)-5,7)+5
Thank you for the formula to find out thanks giving day. I've used it to generate this holidays (and others) dates here: https://www.whenholiday.com/en-us/thanksgiving-day/