"Thanksgiving Day" in Microsoft Excel 2010

Thanks Giving day is a national holiday in the United States and Canada and it’s a harvest festival. It is celebrated on the second Monday of October in Canada and fourth Thursday of November in United States.

In this article we will learn about how we can count no. of days till the Thanks Giving day and how we can return the date if we know that the festival should be on 4^th Thursday and 2^nd Monday of the month.
Return the Date for Thanks Giving Day

To return the date for Thanks Giving Day we use the Date, Choose, Weekday formula in Microsoft Excel 2010 and 2013.

Date: - Returns the number that represents the date in Microsoft Excel date-time code.

The Syntax of Date:- =Date (year, month, date)
Choose: - Choose a value or action to perform from a list of values, based on an index number.

The Syntax of Choose:- =Choose (index_num, value1, value2)
Weekday: - Returning a number 1 to 7 identifying the day of the week of a date.

The Syntax of Weekday:- =Weekday (serial_number, return_type)

Let’s take an example and understand. Column A contains the years 2010 to 2018. We need to find out that what day of week 4^th day of November.

To return the date for Thanks giving Day for United States follow below given steps:

Select the cell B2 and write the formula.
=DATE(A2,11,CHOOSE(WEEKDAY(DATE(A2,11,1)),26,25,24,23,22,28,27)), press enter.
The function will return the date of 4^th Thursday of November inthe year of 2010.
To return the date for all the years copy the same formula by pressing the key Ctrl+C and paste into the range B3:B10 by pressing the key Ctrl+V on your keyboard.

To return the date for Thanks giving Day for Canada follow below given steps:

Select the cell C2 and write the formula.
=DATE(A2,10,CHOOSE(WEEKDAY(DATE(A2,10,1)),9,8,14,13,12,11,10)), press enter.
The function will return the date of 4^th Thursday of November in the year of 2010.
To return the date for all the years copy the same formula by pressing the key Ctrl+C and paste into the range C3:C10 by pressing the key Ctrl+V on your keyboard.

To calculate the no. of days from today we use the formula “Today” in Microsoft Excel.

In this article we use the “Today” formula to return the current date.

Select the cell D2 and write the formula.
=TODAY(), press enter.
The function will return the today’s date.
To return the date for all the years copy the same formula by pressing the key Ctrl+C and paste into the range D3:D10 by pressing the key Ctrl+V on your keyboard.

To return the no. of days till the Thanks Giving Day for United States follow below given steps:-

Select the cell E2 and write the formula.
=B2-$D$2, press enter.
The function will return the pending no. of days till the Thanks Giving Day.
To return the same for all the years copy the same formula by pressing the key Ctrl+C and paste into the range E3:E10 by pressing the key Ctrl+V on your keyboard.

To return the no. of days till the Thanks Giving Day in Canada follow below given steps:-

Select the cell F2 and write the formula.
=C2-$D$2, press enter.
The function will return the pending no. of days till the Thanks Giving Day.
To return the same for all the years copy the same formula by pressing the key Ctrl+C and paste into the range F3:F10 by pressing the key Ctrl+V on your keyboard.