On the Memberships sheet, what is the best formula to always show the current date in B4? On the Memberships sheet, what is the name of the best function to use in the formula for E11? On the Memberships sheet, what is the best formula to use in E11? On the Memberships sheet, what is the name of the best function to use in the formula in B7? On the Memberships sheet, what is the best formula to use in B8? On the Memberships sheet, what is the name of the best function to use in the formula in C7? On the Memberships sheet, what is the best formula to use in C8? TODAY'S DATE Number of Members Total of Renewal Amounts Active Members Expired Members Acct # Member's Name Renewal Date Renewal Amount Status: Active or Expired 1001 Miller, Mike 10/15/2015 $300 1002 Bonaventura, Bill & Bobbi 12/24/2015 $150 1003 Smith, Sam 3/15/2016 $300 1004 Wilson, Wayne & Wendy 4/1/2016 $175 1005 Laredo, Lance & Lisa 8/1/2015 $300 1006 Jones, Jim & Joni 1/1/2016 $300 1007 Night, Bob 7/31/2017 $150 1008 Tanner, Tom & Trudy 10/31/2015 $250 1009 Jackson, James & Jenna 3/15/2016 $300 1010 Thompson, Mark & Christy 4/15/2016 $175 1011 Cruz, Maria 3/15/2015 $300 1012 Jordan, Jeff 11/10/2016 $500 1013 Johnson, Sally 4/1/2016 $300 1014 Smith, Bob & Jane 7/31/2015 $225 1015 Williams, Pat 9/25/2017 $300