Google-sheets – Auto calculate three weeks ahead in Google Sheets google sheets Is it possible to put a date in a cell and the cell next to it will automatically pull that date and add three weeks to it? Example in picture below: Best Answer Yes. D2: =C2+21 Format as number> date, If necessary. Related SolutionsGoogle Sheets – How to Fill a Column with Sequential Dates The key is to enter at least the first two values to get auto fill to work with a pattern Google-sheets – Conditional formatting for dates in Google sheets With New Google Sheets please try Custom formula is: =today()-a1>7 with Background red and Range: to suit =and(A1-today()>0,A1-today()<28) with Background green and same Range: =A1-today()>=28 with Background white and same Range: Related TopicGoogle-sheets – How to pull information from google sheets based on a date rangeGoogle-sheets – how to auto calculate valuesGoogle-sheets – Google Sheets auto move to next cellGoogle Sheets – Color Row Based on Closest Date to TodayGoogle-sheets – Autofill Google sheets template based on new entries in column A of “master” sheet
Best Answer
Yes.
D2:
Format as number> date, If necessary.