I enter the formula, and it puts VALUE in the table instead of the number of days and sometimes it solves it with subtracting the dates and gets 3/16/1900. I'm not sure how to get it to display the number of actual days.
Add a new column in column I named Days on Market. Use unqualified structured references to calculate the days on market (Sale Date Listing Date) in column I. Set column l's width to 14. G2 =[ @[Sale Date]]-[@[Listing Date]] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A B D Trans II Address City Selling Agen 1 8687 Kenwood Road Cedar Hills Hernandez 2 11 West Oak Circle American Fork Carey 3 314 Timp View Drive American Fork Goodrich 4 614 West Cedar Drive Lehi Lugo 5 750 South Apple Way American Fork Goodrich 6 6379 Columbia Circle Alpine Carey 7 6334 Lendsmith Circle Lehi Lugo 8 321 North Choctaw American Fork Minkus 9 1370 Pinellas Road Alpine Lugo 10 1971 Glenview Road Lehi Minkus 11 7410 Wood Court American Fork Hernandez 12 575 South Choctaw Alpine Goodrich 13 10995 SW 88 Court Lehi Goodrich 14 143 North Mountain View American Fork Carey 15 29 East Oak Circle American Fork Merkin 16 8030 Steeplechase Drive Alpine Merkin 17 1057 West 58th St. Alpine Minkus 18 9876 South Sunset Avenue Eagle Mountain Hernandez 19 321 West Walnut Grove American Fork Goodrich 20 4081 Lybyer Avenue Alpine Minkus Annnnx Sales Data $ $ $ $ $ $ $ $ $ $ E F List Price - Selling Price 725,000 $ 645,250 350,000 $ 340,000 418,000 $ 400,000 215,800 $ 200,000 385,900 $ 385,900 500,000 $ 465,000 300,000 $ 290,000 565,000 $ 535,000 219,000 $ 215,000 165,000 $ 156,750 325,000 $ 320,000 750,250 $ 700,000 110,000 $ 106,000 314,250 $ 304,000 555,000 $ 500,000 450,000 $ 382,500 345,000 $ 339,999 300,000 $ 300,000 425,000 $ 415,000 325,000 $ 308,750 G Listing Dat 4/1/2021 4/1/2021 4/1/2021 4/1/2021 4/1/2021 4/3/2021 4/3/2021 4/6/2021 4/8/2021 4/12/2021 4/12/2021 4/12/2021 4/12/2021 4/13/2021 4/13/2021 4/15/2021 4/18/2021 4/18/2021 4/18/2021 4/19/2021 H J K Sale Dat Days on Mark 6/16/2021 = @[Sale Date]]-[@[Listing Date]]|| 5/15/2021 6/1/2021 5/25/2021 4/30/2021 6/10/2021 6/1/2021 9/30/2021 6/2/2021 6/12/2021 5/30/2021 11/1/2021 7/3/2021 8/5/2021 10/15/2021 6/30/2021 6/23/2021 4/30/2021 6/30/2021 7/2/2021 $ $ $ $ $ LL: 20 non A1014 Linn
