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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History