Autofilling dates

%3CLINGO-SUB%20id%3D%22lingo-sub-1479780%22%20slang%3D%22en-US%22%3EAutofilling%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479780%22%20slang%3D%22en-US%22%3EHow%20do%20I%20advance%20a%20date%20in%20c2%20i.e.%2001.01.20%20by%207%20days%20so%20that%20c3%20becomes%2001.07.20%20and%20then%20autofill%20each%20subsequent%20cell%20so%20that%20the%20date%20aligns%20with%20the%20week%20numbers%201-52%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
How do I advance a date in c2 i.e. 01.01.20 by 7 days so that c3 becomes 01.07.20 and then autofill each subsequent cell so that the date aligns with the week numbers 1-52?
1 Reply
the excel format is based on days so =C2+7 would work and then filling down that column will give you each week. You might want or need to tweak the number format for the column to make sure the dates are shown in the format/style you want to see