Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: excel datesThanks for the reply. I tend to use capitals because I am a slow typist!excel dates IF I HAVE A DATE IN COLUMN AI, SAY 1/1/22 AND I DRAG & DROP IT TO A2, IT CHANGES TO 2/1/22. IS THERE AN OPTION I CAN CHOOSE SO IT JUST REPEATS 1/1/22? THANKS FOR ANY HELP, DAVID ROPER