cox_samCopper ContributorJan 27, 2022SolvedSUMPRODUCT with Text Hi all, I am trying to write an equation that will count every instance two dates are more than 30 days apart. The spreadsheet is a living and growing document so having open ranges would be preferr...Show MoreSergeiBaklanJan 27, 2022cox_sam
chahineIron ContributorJan 27, 2022first ensure your dates are numbers , as i see they are text dates, then it should work
cox_samCopper Contributor to chahineJan 27, 2022On my actual spreadsheet, they are Custom m/d/yyyy;;"" When I change it to dates or to numbers, I still have the same #VALUE! problem unfortunately
