On January 1st I am given goals in an excel worksheet, Broken down by month. For example in cell A18 is January, cell C18 is the percentage. Ex: 2.25%. February is in cell A19 and the percentage for February is in cell C19 Ex: 2.00%. March in cell A20 and so on. Every month is a new percentage. Then daily I import a number into cell B2 that I times by the percentage for the correct month. In cell C3 I have a formula that I have to change monthly. Example =B2*D18 for January in February I change the formula to B2*C19. Is there a way for excel to automatically change the formula for me on the 1st of every month?