“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 4th Thursday and 2nd 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 4th day of November.
img1

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 4th 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.

img2
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 4th 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.

img3

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.

img4

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.

img5

img6

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.

img7

This way you can calculate the no. of days from today till the thanks giving day in Microsoft Excel 2010 and 2013.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube