How to use #Excel
to calculate when #Thanksgiving
falls on any year: it falls on the 4th Thursday in November, so we find what day of the week November 1st is, then add enough days. We do this by nesting the Date, Weekday and Choose functions. This year, November 1st was a Tuesday, so Thanksgiving is the 24th.
Put the year (2016) in A2, then enter this formula in any cell:
We can even create a table. Enter some years down a column, then in an adjacent column, AutoFill this formula down the column.