Solved Calculate Thanksgiving Day for the next 15 years using excel

November 25, 2014 at 11:10:05
Specs: Windows 7
Use Excel formula to calculate Thanksgiving Day 15 years in the future using the formulas Date & Time function. Or a better solution within excel

See More: Calculate Thanksgiving Day for the next 15 years using excel

Report •


#1
November 25, 2014 at 13:11:08
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

http://www.skeptic.com/


Report •

#2
November 25, 2014 at 13:14:33
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.

Always pop back and let us know the outcome - thanks


Report •

#3
November 26, 2014 at 05:48:10
✔ Best Answer
..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.


Report •

Related Solutions

#4
December 1, 2014 at 05:51:47
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

Report •

Ask Question