Spreadsheet: 815274d1674840904-extract-data-from-cell-book1
Sheet: Sheet1

Payment date |  | Transaction Description | Date from Decrp | Location from [NAME]
 |  | 10/8/2021 CHARLESTON
 |  | 10/1/2021 PLYMOUTH
 |  | 09/29.2021 BOSTON
 |  | WILMINGTON NC 10.15.21
 |  | TENDER RESERVATION SEP-0CT21
 |  | PREFUND BOSTON USA 29-SEP-21
 |  | VANTAGE PF-BOSTON OCT.2021
 |  | 10/7/2021 [NAME]
 |  | 10/8/2021 CHARLESTON
 |  | DA Norkfolk, VA 10/06/21
 |  | DA BOSTON, MA 10/23/21
 |  | DA NORFOLK, VA 10/16/21
 |  | DA Norkfolk, VA 10/06/21
 |  | example exceptions causing errors |  |  | comments
 |  | DA USHUAIA, ARGENTINA |  |  | No date gives me #[NAME]! Error, maybe change to just blank if no date in cell, same applies for location, is no location found in cell just give me a blank
 |  | (blank) |  |  | if row is blank than it should be blank in both columns
 |  | PREFUND CARRIER BOND SEP25-21 |  |  | Date is really 09/25/2021, but doesn't format correctly because it's not typed correctly
 |  | 9/13/2022 to 9/13/2023 |  |  | gave me two lines, doesn’t work if there is a formula in the cell below, comes out as #SPILL! Error
2022-10-31 00:00:00 |  | DA OSLO, NORWAY 7/14 |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really be 07/14/2022, can this be done?
2022-10-31 00:00:00 |  | DA [NAME], NORWAY 7/12 |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really be 07/12/2022
2022-10-31 00:00:00 |  | DA STAVANGER, NORWAY 7/17 |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really be 07/17/2022
2022-10-26 00:00:00 |  | Oct.23 CAP-AUX-MEULES, CANADA |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really 10/23/2023
2022-10-26 00:00:00 |  | Oct.21 BAIE COMEAU, CANADA |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really be 10/21/2023
2022-10-26 00:00:00 |  | Oct.18 QUEBEC CITY, CANADA |  |  | defaults to current year if no year is given, but the payment date is really in 2022, so date would really be 10/18/2023
 |  | [NAME] Aug 22 Reykjavik |  |  | don't think we can get 08/01/2022 from this cell
 |  | DA PICTOU,NOVA SCOTIA5/2-20/22 |  |  | if no space between name and date, it pulls the name into the date
 |  | DA LUNENBURG, NOVA SCOTIA4/30 |  |  | if no space between name and date, it pulls the name into the date
 |  | CANSO LOCK 10052022 |  |  | date is 10/05/2022, no idea on making the formula recognize date without a dash or periods seperating
 |  | QUEBEC CITY 09302022 |  |  | date is 09/30/2022, no idea on making the formula recognize date without a dash or periods seperating
 |  | '4/30/2022 LUNENBURG |  |  | if there is a single quote in front of the date, formula picks it up
 |  | BAIE COMEAU PREPAYMENT  100122 |  |  | date is formated as what "100122" should be, but in reality it's 10/01/2022, also don’t know why there is a #[NAME] error in the Location column, should be "BAIE COMEAU PREPAYMENT"
 |  | Little Current,Canada Jun.3-22 |  |  | Another formating error, almost worked but seems like the dash is causing the issue to properly put 06/03/2022
 |  | Toronto,Canada May.29-22 |  |  | Another formating error, almost worked but seems like the dash is causing the issue to properly put [NAME]
 |  | Johnstown,Canada Sep.6-22 |  |  | Another formating error, almost worked but seems like the dash is causing the issue to properly put [NAME]
 |  | PF CHARLESTON-11/04/21 |  |  | This one got me, don't know why it wouldn't place them properly, 11/04/2021 for date and Charleston for location