Section II - Date Formulas Quiz

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 15

Exercises: Column B shows Total Sales for each date listed in Column A.

Using Date formulas, fill in the Year, Month, Day and


respectively. Then, use custom formats to fill in the Full Month Name in Column E, and Full Weekday Name in Column H.
(Examples are provided in Row 8 for the output of each column).
Finally (so you don't forget it), use a SUMIF formula in column O, to determine the total sales for each weekday, including Ro

Date Total Sales Year Month Full Month Name Day Weekday
6/3/2012 $2,150 2012 6 June 3 1
4/2/2012 $5,000 2012 4 April 2 2
10/13/2011 $4,893 2011 10 October 13 5
8/29/2011 $2,032 2011 8 August 29 2
8/20/2011 $5,678 2011 8 August 20 7
5/5/2011 $2,143 2011 5 May 5 5
1/9/2011 $3,214 2011 1 January 9 1
12/4/2010 $3,521 2010 12 December 4 7
11/4/2010 $6,451 2010 11 November 4 5
10/19/2010 $2,194 2010 10 October 19 3
9/13/2010 $4,408 2010 9 September 13 2
8/24/2010 $3,599 2010 8 August 24 3
8/16/2010 $1,124 2010 8 August 16 2
8/2/2010 $2,199 2010 8 August 2 2
7/28/2010 $4,336 2010 7 July 28 4
6/16/2010 $8,610 2010 6 June 16 4
5/22/2010 $3,622 2010 5 May 22 7
5/17/2010 $1,600 2010 5 May 17 2
5/12/2010 $6,795 2010 5 May 12 4
1/25/2010 $5,082 2010 1 January 25 2
12/25/2009 $2,965 2009 12 December 25 6
12/22/2009 $5,399 2009 12 December 22 3
8/11/2009 $3,796 2009 8 August 11 3
8/4/2009 $2,725 2009 8 August 4 3
8/3/2009 $6,032 2009 8 August 3 2
7/15/2009 $7,672 2009 7 July 15 4
6/29/2009 $8,956 2009 6 June 29 2
6/1/2009 $3,263 2009 6 June 1 2
2/25/2009 $3,883 2009 2 February 25 4
2/13/2009 $8,320 2009 2 February 13 6
2/13/2009 $3,428 2009 2 February 13 6
1/15/2009 $1,767 2009 1 January 15 5
11/28/2008 $8,162 2008 11 November 28 6
10/7/2008 $1,080 2008 10 October 7 3
9/14/2008 $7,459 2008 9 September 14 1
8/26/2008 $4,428 2008 8 August 26 3
8/24/2008 $4,436 2008 8 August 24 1
8/20/2008 $8,359 2008 8 August 20 4
8/3/2008 $6,738 2008 8 August 3 1
6/10/2008 $8,153 2008 6 June 10 3
5/30/2008 $7,397 2008 5 May 30 6
4/15/2008 $4,179 2008 4 April 15 3
4/3/2008 $4,468 2008 4 April 3 5
1/11/2008 $5,649 2008 1 January 11 6
1/5/2008 $1,532 2008 1 January 5 7
1/4/2008 $5,230 2008 1 January 4 6
11/30/2007 $5,055 2007 11 November 30 6
10/4/2007 $3,904 2007 10 October 4 5
9/16/2007 $6,293 2007 9 September 16 1
9/11/2007 $1,381 2007 9 September 11 3
8/31/2007 $3,685 2007 8 August 31 6
8/26/2007 $8,296 2007 8 August 26 1
8/20/2007 $4,996 2007 8 August 20 2
8/18/2007 $3,397 2007 8 August 18 7
8/9/2007 $7,282 2007 8 August 9 5
7/29/2007 $5,098 2007 7 July 29 1
7/23/2007 $3,571 2007 7 July 23 2
7/21/2007 $4,841 2007 7 July 21 7
7/18/2007 $2,633 2007 7 July 18 4
7/17/2007 $8,732 2007 7 July 17 3
7/5/2007 $8,158 2007 7 July 5 5
7/5/2007 $2,100 2007 7 July 5 5
6/30/2007 $8,984 2007 6 June 30 7
6/29/2007 $2,173 2007 6 June 29 6
6/28/2007 $6,595 2007 6 June 28 5
6/27/2007 $3,424 2007 6 June 27 4
6/25/2007 $1,808 2007 6 June 25 2
6/21/2007 $2,641 2007 6 June 21 5
6/18/2007 $7,166 2007 6 June 18 2
5/17/2007 $7,973 2007 5 May 17 5
5/5/2007 $3,910 2007 5 May 5 7
4/25/2007 $2,148 2007 4 April 25 4
4/18/2007 $8,278 2007 4 April 18 4
4/12/2007 $8,819 2007 4 April 12 5
4/10/2007 $5,866 2007 4 April 10 3
3/30/2007 $1,118 2007 3 March 30 6
3/23/2007 $1,465 2007 3 March 23 6
3/17/2007 $4,243 2007 3 March 17 7
3/12/2007 $6,770 2007 3 March 12 2
3/7/2007 $7,762 2007 3 March 7 4
2/21/2007 $7,137 2007 2 February 21 4
2/15/2007 $3,533 2007 2 February 15 5
2/13/2007 $5,088 2007 2 February 13 3
2/11/2007 $8,334 2007 2 February 11 1
2/8/2007 $1,540 2007 2 February 8 5
2/7/2007 $8,330 2007 2 February 7 4
1/25/2007 $5,142 2007 1 January 25 5
1/24/2007 $6,672 2007 1 January 24 4
1/24/2007 $4,737 2007 1 January 24 4
1/22/2007 $1,656 2007 1 January 22 2
1/12/2007 $6,774 2007 1 January 12 6
12/29/2006 $1,309 2006 12 December 29 6
12/28/2006 $2,970 2006 12 December 28 5
12/28/2006 $5,186 2006 12 December 28 5
12/24/2006 $8,200 2006 12 December 24 1
12/12/2006 $4,046 2006 12 December 12 3
11/12/2006 $6,773 2006 11 November 12 1
11/1/2006 $6,320 2006 11 November 1 4
10/30/2006 $7,944 2006 10 October 30 2
10/29/2006 $2,380 2006 10 October 29 1
10/19/2006 $5,244 2006 10 October 19 5
10/10/2006 $4,470 2006 10 October 10 3
10/3/2006 $8,134 2006 10 October 3 3
9/29/2006 $2,159 2006 9 September 29 6
9/26/2006 $5,436 2006 9 September 26 3
9/1/2006 $7,617 2006 9 September 1 6
8/22/2006 $3,373 2006 8 August 22 3
8/15/2006 $1,178 2006 8 August 15 3
8/3/2006 $1,818 2006 8 August 3 5
7/31/2006 $7,909 2006 7 July 31 2
7/29/2006 $5,395 2006 7 July 29 7
7/10/2006 $6,638 2006 7 July 10 2
7/9/2006 $2,117 2006 7 July 9 1
6/30/2006 $6,945 2006 6 June 30 6
6/23/2006 $6,801 2006 6 June 23 6
6/20/2006 $6,101 2006 6 June 20 3
6/17/2006 $6,752 2006 6 June 17 7
6/17/2006 $7,780 2006 6 June 17 7
6/2/2006 $5,567 2006 6 June 2 6
6/2/2006 $5,589 2006 6 June 2 6
5/6/2006 $8,735 2006 5 May 6 7
5/5/2006 $6,877 2006 5 May 5 6
5/5/2006 $5,775 2006 5 May 5 6
5/5/2006 $5,978 2006 5 May 5 6
5/4/2006 $5,668 2006 5 May 4 5
5/3/2006 $5,576 2006 5 May 3 4
3/28/2006 $6,855 2006 3 March 28 3
3/24/2006 $7,045 2006 3 March 24 6
3/18/2006 $8,035 2006 3 March 18 7
3/11/2006 $4,595 2006 3 March 11 7
3/5/2006 $5,894 2006 3 March 5 1
3/4/2006 $5,770 2006 3 March 4 7
3/2/2006 $5,015 2006 3 March 2 5
2/14/2006 $6,775 2006 2 February 14 3
1/25/2006 $7,987 2006 1 January 25 4
1/24/2006 $4,328 2006 1 January 24 3
1/21/2006 $6,346 2006 1 January 21 7
1/3/2006 $2,292 2006 1 January 3 3
12/24/2005 $7,572 2005 12 December 24 7
12/23/2005 $1,384 2005 12 December 23 6
12/8/2005 $1,434 2005 12 December 8 5
11/21/2005 $8,244 2005 11 November 21 2
11/19/2005 $2,264 2005 11 November 19 7
11/14/2005 $7,752 2005 11 November 14 2
10/22/2005 $8,694 2005 10 October 22 7
10/19/2005 $2,476 2005 10 October 19 4
10/18/2005 $6,482 2005 10 October 18 3
10/4/2005 $3,159 2005 10 October 4 3
9/21/2005 $3,593 2005 9 September 21 4
9/9/2005 $1,955 2005 9 September 9 6
9/5/2005 $8,226 2005 9 September 5 2
9/5/2005 $6,470 2005 9 September 5 2
9/2/2005 $8,156 2005 9 September 2 6
8/23/2005 $5,913 2005 8 August 23 3
8/19/2005 $4,766 2005 8 August 19 6
8/16/2005 $7,579 2005 8 August 16 3
8/14/2005 $1,359 2005 8 August 14 1
8/6/2005 $7,123 2005 8 August 6 7
8/2/2005 $5,428 2005 8 August 2 3
8/1/2005 $6,357 2005 8 August 1 2
7/19/2005 $1,733 2005 7 July 19 3
7/16/2005 $4,915 2005 7 July 16 7
6/29/2005 $3,120 2005 6 June 29 4
6/12/2005 $8,081 2005 6 June 12 1
6/8/2005 $7,023 2005 6 June 8 4
5/22/2005 $8,187 2005 5 May 22 1
5/20/2005 $3,385 2005 5 May 20 6
5/10/2005 $4,782 2005 5 May 10 3
5/5/2005 $1,764 2005 5 May 5 5
4/20/2005 $5,608 2005 4 April 20 4
3/19/2005 $2,709 2005 3 March 19 7
3/16/2005 $2,482 2005 3 March 16 4
3/7/2005 $6,747 2005 3 March 7 2
3/6/2005 $1,347 2005 3 March 6 1
2/21/2005 $2,920 2005 2 February 21 2
1/24/2005 $8,264 2005 1 January 24 2
1/21/2005 $7,235 2005 1 January 21 6
1/13/2005 $3,999 2005 1 January 13 5
10/22/2004 $5,683 2004 10 October 22 6
10/19/2004 $1,954 2004 10 October 19 3
10/19/2004 $1,106 2004 10 October 19 3
10/14/2004 $7,891 2004 10 October 14 5
9/16/2004 $6,581 2004 9 September 16 5
9/6/2004 $4,217 2004 9 September 6 2
8/30/2004 $7,587 2004 8 August 30 2
8/27/2004 $6,103 2004 8 August 27 6
8/24/2004 $3,432 2004 8 August 24 3
8/24/2004 $5,039 2004 8 August 24 3
8/21/2004 $3,715 2004 8 August 21 7
8/17/2004 $8,003 2004 8 August 17 3
8/16/2004 $6,296 2004 8 August 16 2
8/11/2004 $2,633 2004 8 August 11 4
8/9/2004 $6,000 2004 8 August 9 2
8/7/2004 $6,083 2004 8 August 7 7
7/29/2004 $7,531 2004 7 July 29 5
7/26/2004 $4,450 2004 7 July 26 2
6/26/2004 $1,124 2004 6 June 26 7
6/16/2004 $6,369 2004 6 June 16 4
6/8/2004 $1,546 2004 6 June 8 3
6/1/2004 $1,805 2004 6 June 1 3
5/18/2004 $1,375 2004 5 May 18 3
5/11/2004 $4,056 2004 5 May 11 3
5/9/2004 $8,506 2004 5 May 9 1
4/27/2004 $6,030 2004 4 April 27 3
4/9/2004 $1,301 2004 4 April 9 6
4/2/2004 $6,796 2004 4 April 2 6
3/19/2004 $5,272 2004 3 March 19 6
3/17/2004 $7,844 2004 3 March 17 4
3/7/2004 $5,628 2004 3 March 7 1
3/1/2004 $7,697 2004 3 March 1 2
2/10/2004 $7,980 2004 2 February 10 3
2/8/2004 $1,613 2004 2 February 8 1
2/4/2004 $5,487 2004 2 February 4 4
1/28/2004 $8,169 2004 1 January 28 4
1/17/2004 $4,383 2004 1 January 17 7
1/15/2004 $5,704 2004 1 January 15 5
1/5/2004 $6,266 2004 1 January 5 2
1/3/2004 $6,454 2004 1 January 3 7
12/27/2003 $1,108 2003 12 December 27 7
12/25/2003 $4,981 2003 12 December 25 5
12/20/2003 $3,436 2003 12 December 20 7
12/19/2003 $5,103 2003 12 December 19 6
12/16/2003 $4,926 2003 12 December 16 3
12/4/2003 $3,952 2003 12 December 4 5
11/21/2003 $2,990 2003 11 November 21 6
11/17/2003 $4,687 2003 11 November 17 2
11/3/2003 $5,693 2003 11 November 3 2
10/20/2003 $4,981 2003 10 October 20 2
10/13/2003 $4,591 2003 10 October 13 2
10/11/2003 $2,498 2003 10 October 11 7
9/24/2003 $6,696 2003 9 September 24 4
9/20/2003 $4,278 2003 9 September 20 7
9/4/2003 $5,050 2003 9 September 4 5
8/30/2003 $4,681 2003 8 August 30 7
8/27/2003 $1,991 2003 8 August 27 4
8/19/2003 $4,817 2003 8 August 19 3
8/19/2003 $5,739 2003 8 August 19 3
8/2/2003 $4,683 2003 8 August 2 7
8/1/2003 $3,071 2003 8 August 1 6
7/11/2003 $5,239 2003 7 July 11 6
7/8/2003 $4,552 2003 7 July 8 3
6/16/2003 $7,917 2003 6 June 16 2
6/14/2003 $5,598 2003 6 June 14 7
5/29/2003 $4,740 2003 5 May 29 5
5/26/2003 $8,500 2003 5 May 26 2
5/26/2003 $2,014 2003 5 May 26 2
5/24/2003 $7,497 2003 5 May 24 7
5/16/2003 $4,118 2003 5 May 16 6
4/29/2003 $3,550 2003 4 April 29 3
4/23/2003 $5,400 2003 4 April 23 4
4/22/2003 $4,921 2003 4 April 22 3
4/18/2003 $3,723 2003 4 April 18 6
4/9/2003 $2,839 2003 4 April 9 4
3/31/2003 $4,162 2003 3 March 31 2
3/28/2003 $3,490 2003 3 March 28 6
3/26/2003 $2,198 2003 3 March 26 4
3/26/2003 $1,968 2003 3 March 26 4
3/21/2003 $3,690 2003 3 March 21 6
3/19/2003 $2,013 2003 3 March 19 4
3/12/2003 $8,443 2003 3 March 12 4
3/12/2003 $3,612 2003 3 March 12 4
3/6/2003 $2,651 2003 3 March 6 5
3/5/2003 $4,605 2003 3 March 5 4
2/19/2003 $1,778 2003 2 February 19 4
2/7/2003 $6,970 2003 2 February 7 6
2/2/2003 $5,300 2003 2 February 2 1
1/29/2003 $7,346 2003 1 January 29 4
1/26/2003 $7,662 2003 1 January 26 1
1/24/2003 $1,624 2003 1 January 24 6
1/24/2003 $8,096 2003 1 January 24 6
1/23/2003 $6,254 2003 1 January 23 5
1/19/2003 $1,312 2003 1 January 19 1
1/19/2003 $1,482 2003 1 January 19 1
1/19/2003 $2,987 2003 1 January 19 1
1/18/2003 $3,845 2003 1 January 18 7
1/17/2003 $1,646 2003 1 January 17 6
1/17/2003 $7,816 2003 1 January 17 6
1/17/2003 $1,240 2003 1 January 17 6
1/14/2003 $6,836 2003 1 January 14 3
1/14/2003 $3,809 2003 1 January 14 3
1/9/2003 $7,251 2003 1 January 9 5
1/8/2003 $7,266 2003 1 January 8 4
1/6/2003 $2,043 2003 1 January 6 2
ulas, fill in the Year, Month, Day and Weekday in Columns C, D, F, and G
ull Weekday Name in Column H.

sales for each weekday, including Row 8.

Full Weekday Name Month Month Name Weekday Weekday Name


Sunday 1 January 1 Sunday
Monday 2 February 2 Monday
Thursday 3 March 3 Tuesday
Monday 4 April 4 Wednesday
Saturday 5 May 5 Thursday
Thursday 6 June 6 Friday
Sunday 7 July 7 Saturday
Saturday 8 August
Thursday 9 September
Tuesday 10 October
Monday 11 November
Tuesday 12 December
Monday
Monday
Wednesday
Wednesday
Saturday
Monday
Wednesday
Monday
Friday
Tuesday
Tuesday
Tuesday
Monday
Wednesday
Monday
Monday
Wednesday
Friday
Friday
Thursday
Friday
Tuesday
Sunday
Tuesday
Sunday
Wednesday
Sunday
Tuesday
Friday
Tuesday
Thursday
Friday
Saturday
Friday
Friday
Thursday
Sunday
Tuesday
Friday
Sunday
Monday
Saturday
Thursday
Sunday
Monday
Saturday
Wednesday
Tuesday
Thursday
Thursday
Saturday
Friday
Thursday
Wednesday
Monday
Thursday
Monday
Thursday
Saturday
Wednesday
Wednesday
Thursday
Tuesday
Friday
Friday
Saturday
Monday
Wednesday
Wednesday
Thursday
Tuesday
Sunday
Thursday
Wednesday
Thursday
Wednesday
Wednesday
Monday
Friday
Friday
Thursday
Thursday
Sunday
Tuesday
Sunday
Wednesday
Monday
Sunday
Thursday
Tuesday
Tuesday
Friday
Tuesday
Friday
Tuesday
Tuesday
Thursday
Monday
Saturday
Monday
Sunday
Friday
Friday
Tuesday
Saturday
Saturday
Friday
Friday
Saturday
Friday
Friday
Friday
Thursday
Wednesday
Tuesday
Friday
Saturday
Saturday
Sunday
Saturday
Thursday
Tuesday
Wednesday
Tuesday
Saturday
Tuesday
Saturday
Friday
Thursday
Monday
Saturday
Monday
Saturday
Wednesday
Tuesday
Tuesday
Wednesday
Friday
Monday
Monday
Friday
Tuesday
Friday
Tuesday
Sunday
Saturday
Tuesday
Monday
Tuesday
Saturday
Wednesday
Sunday
Wednesday
Sunday
Friday
Tuesday
Thursday
Wednesday
Saturday
Wednesday
Monday
Sunday
Monday
Monday
Friday
Thursday
Friday
Tuesday
Tuesday
Thursday
Thursday
Monday
Monday
Friday
Tuesday
Tuesday
Saturday
Tuesday
Monday
Wednesday
Monday
Saturday
Thursday
Monday
Saturday
Wednesday
Tuesday
Tuesday
Tuesday
Tuesday
Sunday
Tuesday
Friday
Friday
Friday
Wednesday
Sunday
Monday
Tuesday
Sunday
Wednesday
Wednesday
Saturday
Thursday
Monday
Saturday
Saturday
Thursday
Saturday
Friday
Tuesday
Thursday
Friday
Monday
Monday
Monday
Monday
Saturday
Wednesday
Saturday
Thursday
Saturday
Wednesday
Tuesday
Tuesday
Saturday
Friday
Friday
Tuesday
Monday
Saturday
Thursday
Monday
Monday
Saturday
Friday
Tuesday
Wednesday
Tuesday
Friday
Wednesday
Monday
Friday
Wednesday
Wednesday
Friday
Wednesday
Wednesday
Wednesday
Thursday
Wednesday
Wednesday
Friday
Sunday
Wednesday
Sunday
Friday
Friday
Thursday
Sunday
Sunday
Sunday
Saturday
Friday
Friday
Friday
Tuesday
Tuesday
Thursday
Wednesday
Monday
Total Sales
130846
230235
226160
221618
173093
233935
185796

You might also like