I am trying to repeat dates in several different places, so that I only have to type it once. However, when I use the REPT function I get a number instead of a date format. I've tried to format the cells back to date function, but it doesn't change.