asicoliCopper ContributorNov 28, 2022SolvedSubtracting years I am trying to subtract years from dates in excel and for some reason I keep getting #NUM error. I am using this formula: =DATE(YEAR(A2-2,MONTH(A2),DAY(A2)) Please help! OliverScheurichNov 28, 2022asicoli =DATE(YEAR(A2)-2,MONTH(A2),DAY(A2)) There is only one " ) " missing in the formula.
OliverScheurichNov 28, 2022asicoli =DATE(YEAR(A2)-2,MONTH(A2),DAY(A2)) There is only one " ) " missing in the formula.
OliverScheurichNov 28, 2022asicoli =DATE(YEAR(A2)-2,MONTH(A2),DAY(A2)) There is only one " ) " missing in the formula.
OliverScheurichGold ContributorNov 28, 2022asicoli =DATE(YEAR(A2)-2,MONTH(A2),DAY(A2)) There is only one " ) " missing in the formula.
