I am building out a dynamic excel analysis sheet. Although, when I paste the date for daily performance in it adds 4 years automatically. It is not a local issue ie happens on different versions of excel and different computers. The problem is from this specific document, I have tried to paste all my formulas to a new document, but that recreates the issue. Short of recreating the document, does anyone have any tips? As of now =DATE(YEAR(A2)-4,MONTH(A2),DAY(A2)) is solving my problem, but that is def not a permanent solution



Thanks!!