what formula should i put in c2

Clipboan Alignment Number UPDATES AVAILABLE Updates for Office we ready to to close some apps. Update now =EOMONTH City of interest 3 Albany State NY L AVERAGE MINIMUM MAXIMUM AVERA Averare Temperature ('Farenhet) ANNUAL TEMP AVERAGE TEMP AVERAGE TEMP ANNUALT VALUE! for City Write a formula that converts the for City for Stat 22.2 month name in 10 to the Excel 3 47. 2 2. 21 7 1.1 26.2666 nument that corresponds to the 30th day of that month in the year 2020 MINIMUM MAXIMUM Averar MP AVERAGE TEMP AVERAGE TEMP When you copy the formula from Nationwide Nationwide 34.025 -2 should give you the 3575 3 4.025 75.56 nurseric value of the 30th day of each of the months in CD-F10 7 NATIONWIDE AVERAGEL 11 Albany HNT Use DATEVALUE On a string of the fom 2000 that you constructing CONCATENATE where the month taken relatively 12 Albuquerque 13 Anchorage 14 Asheville 15 Atlanta 16 Atlantic City 17 Austin 21 Birmingham 23 Boise 25 Bridgeport 26 Buffalo 27 Burlington 28 Caribou 29 Caper 10 Charleston 11 Charleston 32 Charlotte 33 Cheyenne 14 Chico Cleveland Weather Example Type here to search N27 State C2 City of Interest 3 Albany 0675 7 NATIONWIDE AVERAGE AVERAGE Average Temperature (Farenheit) ANNUAL TEMP AL (HVALUE JW Jonathan Weiss Write a formula that converts the month name in 10 to the Excel numeric that corresponds to the 30th day of that month in the year Averag MP AV 2020. JAN 1134.025 When you copy the formula from C2-F2, it should give you the numeric value of the 30th day of Average each of the months in C10-F10 JAN 22.2 HINT: Use DATEVALUE on a string of the form "JAN 30, 2020" that you 35.7 construct using CONCATENATE, 15.8 35.8 Reply OLO 50.6 68.3 53.2 66.6 46.1 61.3 State NM 10 City 11 Albany 12 Albuquerque 13 Anchorage 14 Asheville 15 Atlanta 16 Atlantic City 17 Austin 18 Baltimore 19 Baton Rouge 20 Billings 21 Birmingham 22 Bismarck 23 Boise 24 Boston 25 Bridgeport 26 Buffalo 393 6 2 2 353 SSP