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.
