Excel can do more than math — it’s great for working with dates and times too! These Excel formulas help you track days, months, years, and even calculate age or due dates automatically.
- TODAY – Show the Current Date
Displays today’s date (updates automatically each day).
Formula: =TODAY()
👉 Example: If today is October 25, 2025 → result = 25/10/2025
- NOW – Show the Current Date and Time
Shows both the current date and time.
Formula: =NOW()
👉 Example: 25/10/2025 10:30 AM (updates whenever the sheet refreshes)
- DAY – Get the Day from a Date
Pulls out the day number from a date.
Formula: =DAY(A1)
👉 Example: If A1 = 25/10/2025 → result = 25
- MONTH – Get the Month from a Date
Returns the month number from a date.
Formula: =MONTH(A1)
👉 Example: If A1 = 25/10/2025 → result = 10
- YEAR – Get the Year from a Date
Returns the year part of a date.
Formula: =YEAR(A1)
👉 Example: If A1 = 25/10/2025 → result = 2025
- DATEDIF – Find the Difference Between Dates
Calculates the time between two dates (in years, months, or days).
Formula: =DATEDIF(A1, B1, “Y”)
👉 Example: If A1 = 01/01/2000 and B1 = 01/01/2025 → result = 25 years
(Use “M” for months or “D” for days.)
- EDATE – Add or Subtract Months from a Date
Gives you a date that’s a certain number of months before or after another date.
Formula: =EDATE(A1, 6)
👉 Example: If A1 = 01/01/2025 → result = 01/07/2025 (6 months later)
💡 Quick Tip:
- Use TODAY() and DATEDIF() together to calculate age automatically:
- =DATEDIF(A1, TODAY(), “Y”)
👉 Shows age in years based on a birthdate in A1. Stay tuned to ITinsite.in — your trusted source to get more excel formula’s in easy way.
