Help! I’ve worked very hard on the spreadsheet, and I finally figured out my formula for how I want to do it. However, when I copy the formula to the next cell or the entire column it changes the date by one.
Background: I tracking upcoming/overdue due dates. The only formulas for the cell I’m copying is colors, and the other cells have no formulas.
How do I fix it to where it only copies the formula and not change the date to the next date. For example, the cell with the formula is 14-Feb-17 and then when I copy to the next cell, which is 22 Feb 17, it says 15-Feb-17, and the next one is 16 Feb-17 and so on….
Any advice would be helpful.