Excel Study · Module 7: Dates & times
Class 57DATE, YEAR, MONTH, DAY
Intermediate2:08 videoFree
YEAR, MONTH and DAY take a date apart: =YEAR(B2) gives its year, =MONTH(B2) its month number, =DAY(B2) its day.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B3 has a year, B4 a month number and B5 a day. Using DATE, write a formula for B7 that builds the date 3 months later than the date those three cells make.
The answer that works
✓ checked in Excel=DATE(B3,B4+3,B5)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.