Excel: working with dates

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel: working with dates

Excel stores a date as a number of days, so you can subtract dates to get days between them. YEAR, MONTH and DAY pull out parts; DATE builds a date; EDATE moves a date by whole months.

Key words

End − start
Days between two dates.
EDATE(date, 3)
Same day, 3 months later.

🔎 What to look for: A due date "in one month" isn't always 30 days later.

Zero2Hero — Zéro2Héros