In cellI15, enter a function to extract the StartYearof Membership. Copy the function down to the other cells in the column.

InI1enter a function to calculate how many members started membership after the year2008.

___________________

In cellJ15,enter a function to extract the StartMonthof Membership. Copy the function down to the other cells in the column.

InJ1enter a function to calculate how many members started membership afterthe month ofMay.

_____________

In cellK15, enter a function to extract the StartDayof Membership. Copy the function down to the rest of the cells in the column.

InK1enter a function to calculate how many members started membershipon orafter the 15th dayof the month.

In cellL15, enter a function to calculate theDaysof Membership. Copy the function down to the rest of the cells in the column.

InL1enter a function to calculate theaverageDays of membership for all the members.Format as comma style, 0 decimal.

_________________

In cellM15, enter a formula to calculate theYearsof Membership. Copy the formula down to the other cells in the column.

InM1enter a function to calculate theaverageYears of membership for members in the Gardening Club.Format as comma style,1decimal.

_____________

Purpose: To calculate club membership payments over a period using various date f Club Membership Membership ID Last Name 110279 Alvardo 111094 Ramirez 111494 Gines 111517 Smith 111832 Wallace 111903 Zahn 112242 Bonny 112660 Connolley 112790 Ellerman 112979 Anderson 113135 Carlson 113452 Coleman 113584 Allan 113592 Wensien 113803 Longmore 114088 Caine 114093 Carsley 114332 Coombs 114404 Moses 114512 Benson 114573 Henshaw 114626 Fredericksen 114811 Parke 115066 Hinkley 115628 Craig 115731 Carson 115867 Henshaw 116106 Ormsby 116224 Smith 116329 Forbes First Name Marion Jorge Becky Alvin Anthony Xavier Karina Aaron Claretta Amy Tyler Patrick Kim Karen Cecil Francis Mark Hailey Marcella Maxim Jeffrey Johnathan Stanley Garfield Jennifer Roberta Eartha Faith Giana Penelope Gender F M F M M M F M F F M M F F M M M F F M M M M M F F F F F F Annual Cost of Membership $1,641.00 $1,423.00 $1,257.00 $2,076.00 $2,233.00 $1,264.00 $1,227.00 $1,552.00 $1,569.00 $1,657.00 $1,626.00 $2,144.00 $1,321.00 $1,978.00 $2,484.00 $1,264.00 $1,807.00 $1,282.00 $1,640.00 $1,439.00 $1,966.00 $1,615.00 $2,453.00 $2,044.00 $2,264.00 $1,923.00 $2,075.00 $2,031.00 $1,872.00 $2,165.00 117100 Fleming 117158 Delfino 117280 Duquesne 117301 Nation 117363 Lindley 117485 Miller 117511 Nolan 118355 Kinsman 118371 Fortune 118521 Dudley 118596 Adderly 118615 Purcell 118736 Boody 118880 Rushenko 119136 Dekker 119299 Enfield 119522 Berglund 119640 Vandernien 119678 Mortimer 119941 Vacciani Beatrice Mirna Charlie Larry Fiona Nancy Marketta Delores John Paula Michele Joelle Celine Anatasia Jeremy Cynthia Andrea Sheron Michael David F F M M F F F F M F F F F F M F F F M M $1,274.00 $1,941.00 $1,932.00 $2,116.00 $1,449.00 $1,350.00 $2,477.00 $1,259.00 $2,322.00 $2,300.00 $2,096.00 $1,480.00 $2,169.00 $2,370.00 $2,433.00 $1,887.00 $2,470.00 $1,420.00 $1,567.00 $2,265.00 period using various date functions Club Weight Watchers Book Scuba Scuba Gardening Rock Climbing Book Rock Climbing Book Rock Climbing Book Weight Watchers Gardening Weight Watchers Rock Climbing Scuba Hiking Weight Watchers Gardening Scuba Scuba Weight Watchers Rock Climbing Scuba Weight Watchers Gardening Book Rock Climbing Book Gardening Start Date 1-Mar-13 24-Oct-04 30-Sep-12 7-Jun-02 5-Apr-04 29-Mar-13 7-Jul-11 30-Apr-14 2-Jul-09 20-Feb-02 23-Jun-17 28-Nov-12 17-Sep-03 15-Jul-15 23-Sep-08 8-Aug-14 23-Dec-06 22-Apr-03 13-Jan-05 25-Jun-11 20-Dec-14 19-Jun-09 21-Sep-08 24-May-02 21-Jun-11 19-Mar-12 10-Nov-05 11-Jul-08 16-Jan-07 6-Mar-09 End Date 11-Jan-18 12-Dec-14 7-Aug-15 19-Aug-10 16-Jun-15 7-Nov-17 2-Sep-15 7-Oct-17 18-May-18 2-Dec-16 2-Dec-19 23-Oct-16 16-Jan-07 2-Jan-20 20-Jul-12 22-Mar-18 28-Dec-13 29-Jun-14 18-Feb-13 28-Jul-19 12-Oct-19 16-Jun-19 20-Jul-12 7-Oct-18 1-Sep-18 18-Jun-19 14-Apr-14 26-May-10 20-Dec-12 31-Dec-18 Start Year of Membership Book Rock Climbing Scuba Scuba Hiking Scuba Rock Climbing Weight Watchers Hiking Scuba Weight Watchers Book Gardening Weight Watchers Gardening Rock Climbing Hiking Gardening Gardening Hiking 26-Jul-01 17-Aug-11 28-Mar-13 30-Apr-06 16-Jan-12 27-Feb-04 7-Dec-10 30-Dec-01 20-Dec-11 11-Oct-11 1-Sep-08 9-Feb-09 24-Aug-03 31-Jan-09 23-Jan-05 29-Jul-09 4-Dec-05 24-Apr-12 31-Mar-16 17-Jul-03 7-Jan-12 19-Feb-13 6-Nov-17 15-Aug-12 23-Jan-11 19-Mar-17 15-Apr-19 21-Sep-10 29-Jan-18 12-Nov-12 2-Oct-13 30-Jul-17 15-Apr-16 18-Jul-12 3-Jun-11 20-Jun-12 14-Dec-19 27-Feb-20 23-Mar-20 12-Sep-19 Start Month Start Day of Days of Years of Daily Cost of of Membership Membership Membership Membership Membership Monthly Cost Membership High Loyalty Membership of Cost over the Membership Renewal Membership Period Payment Club Discount