Add days to a date
=B2+C2Excel · result on the sample sheet: 5 rows (D2:D6)
Describe what you need and get a working DATE formula for Excel and Google Sheets, tested on real data before you copy it. DATE builds a real date from a year, month and day.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=B2+C2Excel · result on the sample sheet: 5 rows (D2:D6)
=B2+C2*7Excel · result on the sample sheet: 5 rows (D2:D6)
=DATE(A2,B2,C2)Excel · result on the sample sheet: 5 rows (D2:D6)
=COUNTIFS(B2:B11,">="&DATE(G1,1,1),B2:B11,"<"&DATE(G1+1,1,1))Excel · result on the sample sheet: 5
=COUNTIFS(B2:B12,">="&DATE(G1-1,G2,1),B2:B12,"<"&DATE(G1,G2,1))Excel · result on the sample sheet: 7
=COUNTIFS(B2:B13,">="&DATE(G1,G2*3-2,1),B2:B13,"<"&DATE(G1,G2*3+1,1))Excel · result on the sample sheet: 4
=SUMIFS(C2:C10,A2:A10,">="&DATE(YEAR(F1),1,1),A2:A10,"<="&F1)Excel · result on the sample sheet: $15,580
=SUMIFS($C$2:$C$10,$A$2:$A$10,">="&DATE(E2,1,1),$A$2:$A$10,"<="&DATE(E2,12,31))Excel · result on the sample sheet: 3 rows (F2:F4)
You describe the task in plain English, and it writes the formula, using DATE where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
DATE builds a real date from a year, month and day.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the DATE function page has a practice exercise.