📅 Date & Time

Master the 4th Dimension. Learn to calculate deadlines, age, business days, and manipulate time itself.

⌚ Dynamic
01. TODAY / NOW
Get the current date and time. These volatile functions update every time you open the sheet.
🛠️ Construction
02. DATE
Build a valid date from three separate numbers: Year, Month, and Day.
🧩 Extraction
03. YEAR / MONTH / DAY
Break a date apart. Extract just the Year, the Month index, or the Day of the month.
⏱️ Extraction
04. TIME PARTS
Deconstruct time. Extract the Hour, Minute, and Second from a timestamp.
🎂 Secret
05. DATEDIF
The hidden function. Calculate the precise difference between dates in Years, Months, or Days (e.g., Age).
🗓️ Financial
06. EOMONTH / EDATE
Jump forward or backward in time. Find the End of Month (Due Dates) or the exact same day months later.
🚀 Planning
07. WORKDAY
Project Management essential. Calculate a deadline by adding business days (skipping weekends/holidays).
💼 HR / Ops
08. NETWORKDAYS
Calculate working days between two dates. Essential for payroll and project tracking.
📊 Reporting
09. WEEKNUM / WEEKDAY
Weekly reporting tools. Find the Week Number of the year or the Day of the Week (Mon, Tue, etc).
🎨 Formatting
10. TEXT (For Dates)
Convert Serial Dates into readable strings. "Monday, January 1st" using custom codes.
⬅ Back to Excel Menu