Use Excel formula to calculate Thanksgiving Day 15 years in the future using the formulas Date & Time function. Or a better solution within excel

Try this, with the YEAR in A1 enter this formula is B1 =DATE(A1,11,CHOOSE(WEEKDAY(DATE(A1,11,1)),26,25,24,23,22,28,27))

Also, Excel questions are best asked in the Office Software forum.

MIKE

If this is a homework question then make a start on it and then if it doesn't work out post your script on here or seek assistance with the commands available. Whatever, as it is Excel I will ask for the question to be shifted to the Programming forum.

Alwayspop back and let us know the outcome - thanks

..or for our Canadian friends: =DATE(A1,10,CHOOSE(WEEKDAY(DATE(A1,10,1)),9,8,14,13,12,11,10))

Gobble, Gobble, eh?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

DATE(A1,10,CHOOSE(WEEKDAY(DATE(A1,10,1)),9,8,14,13,12,11,10)) was the Best Solution provided by 2 responders! Thank you for all of your help

Ask Your Question

Weekly Poll