Excel Date Functions Cheat Sheet: TODAY, DATEDIF, EOMONTH and More
Quick-reference cheat sheet for Excel date functions: TODAY, DATEDIF, EOMONTH, NETWORKDAYS and more, with syntax and real examples you can copy.
June 11, 2026
Excel Date and Time Functions
This category explores Excel's robust capabilities for working with dates and times, including performing calculations with dates, converting date formats, extracting specific parts of a date, and more.
194 guides in this section
Start here · Complete guide
Dates and Times in Excel: The Complete Guide
Master Excel dates and times: serial numbers, formatting, DATEDIF, NETWORKDAYS, date math, durations, and fixes for text dates and regional format chaos.
Read the guide →
Latest guides
Excel AMORDEGRC Function
Learn how the Microsoft Excel AMORDEGRC function calculates depreciation for each accounting period on a prorated basis. Essential for financial analysis.
April 7, 2024
Excel AMORLINC Function
Discover how the Microsoft Excel AMORLINC function simplifies depreciating assets, providing a detailed guide to its usage and benefits.
April 7, 2024
Excel COUPDAYBS Function
Learn how the Microsoft Excel COUPDAYBS Function calculates days from the start of a coupon period to the settlement date in our latest blog post.
April 7, 2024
Excel COUPDAYS Function
Discover how to use the Microsoft Excel COUPDAYS function to calculate the number of days in a coupon period for financial analysis.
April 7, 2024
Excel COUPDAYSNC Function
Learn how to use the Microsoft Excel COUPDAYSNC function to calculate the days until a bond’s next coupon payment, enhancing your financial analysis.
April 7, 2024
Excel COUPNCD Function
Discover how the Microsoft Excel COUPNCD function helps in calculating the next coupon date after the settlement date for a specified security.
April 7, 2024
Excel COUPNUM Function
Unlock the potential of the Microsoft Excel COUPNUM function to efficiently calculate the number of coupon payments for a bond.
April 7, 2024
Excel COUPPCD Function
Explore the Microsoft Excel COUPPCD Function, your key to calculating the previous coupon date for a specified security, streamlining your finance tasks.
April 7, 2024
All excel date and time functions guides by topic
Functions (38)
- Excel Date Functions Cheat Sheet: TODAY, DATEDIF, EOMONTH and More
- Excel AMORDEGRC Function
- Excel AMORLINC Function
- Excel COUPDAYBS Function
- Excel COUPDAYS Function
- Excel COUPDAYSNC Function
- Excel COUPNCD Function
- Excel COUPNUM Function
- Excel COUPPCD Function
- Excel DAYS360 Function
- Excel FVSCHEDULE Function
- Excel INTRATE Function
- Excel RECEIVED Function
- Excel Date and Time Functions Explained
- Excel DATE Function
- Excel DATEDIF Function
- Excel DATEVALUE Function
- Excel DAY Function
- Excel EDATE Function
- Excel EOMONTH Function
- Excel HOUR Function
- Excel ISOWEEKNUM Function
- Excel MINUTE Function
- Excel MONTH Function
- Excel NETWORKDAYS Function
- Excel NETWORKDAYS.INTL Function
- Excel NOW Function
- Excel SECOND Function
- Excel TIME Function
- Excel TIMEVALUE Function
- Excel TODAY Function
- Excel WEEKDAY Function
- Excel WEEKNUM Function
- Excel WORKDAY Function
- Excel WORKDAY.INTL Function
- Excel YEAR Function
- Excel YEARDIF Function
- Excel YEARFRAC Function
Dates (18)
- Dates and Times in Excel: The Complete Guide
- How to Add Date in Excel
- How to Add Days to a Date in Excel
- How to Add Months to a Date in Excel
- How to Add Years to a Date in Excel
- How to Calculate Age from Date of Birth in Excel
- How to Calculate Date in Excel
- How to Change Date in Excel
- How to Auto Fill Date in Excel
- How to Combine Date and Time in Excel
- How to Convert 8-Digit Number to Date in Excel
- How to Insert Date in Excel
- How to Organize Excel by Date
- How to Remove Time from Date in Excel
- How to Remove Year from Date in Excel
- How to Separate Date and Time in Excel
- What Is Short Date in Excel?
- How to Sort by Date in Excel
Dat (18)
- How to Add Dates in Excel Automatically
- How to Auto Add Dates in Excel
- How to Autofill Dates in Excel
- How to Add Dates in Excel
- How to Auto Populate Dates in Excel
- How to Automatically Fill Dates in Excel
- How to Calculate Days Between Dates in Excel
- How to Calculate Months Between Two Dates in Excel
- Why Does Excel Keep Changing My Numbers to Dates
- How to Get Excel to Stop Changing Numbers to Dates
- How to Insert Dates in Excel Automatically
- How to Make Excel Stop Changing Numbers to Dates
- How to Order Dates in Excel
- How to Organize Dates in Excel
- How to Prevent Excel from Changing Numbers to Dates
- How to Sort Dates in Excel
- How to Stop Excel From Changing Numbers into Dates
- How to Stop Excel from Making Dates
Numbers (8)
Chart axes (7)
Time (7)
Rows (6)
Cells (5)
Data (5)
Addres (5)
Calculations (4)
More guides (73)
- How to Add a Border in Excel
- How to Add a Border to a Chart in Excel
- How to Add a Bullet in Excel
- How to Add a Calendar in Excel
- How to Add a Check Box in Excel
- How to Add a Comma Between Names in Excel
- How to Add a Figure Caption in Excel
- How to Add a Footnote in Excel
- How to Add a Goal Line in Excel
- How to Add a Header in Excel
- How to Add a Leading Zero in Excel
- How to Add a Line of Best Fit in Excel
- How to Add a Note in Excel
- How to Add a Prefix in Excel
- How to Add a Slicer in Excel
- How to Add a Sparkline in Excel
- How to Add a Title in Excel
- How to Add a Watermark in Excel
- How to Add Apostrophe in Excel
- How to Add Chart Title in Excel
- How to Add Check Mark in Excel
- How to Add Comma in Excel
- How to Add Dashes in Excel
- How to Add Dashes to SSN in Excel
- How to Add Developer Tab in Excel
- How to Add Dollar Sign in Excel
- How to Add Filters in Excel
- How to Add Footer in Excel
- How to Add Gridlines in Excel
- How to Add Hours in Excel
- How to Add Legend in Excel
- How to Add Lines in Excel
- How to Add Macros in Excel
- How to Add on Excel
- How to Add on Excel Columns
- How to Add on Excel Spreadsheet
- How to Add Parentheses in Excel
- How to Add Percentages in Excel
- How to Add Print Titles in Excel
- How to Add SD Bars in Excel
- How to Add Signature in Excel
- How to Add Single Quotes in Excel
- How to Add Solver on Excel
- How to Add Solver to Excel on Mac
- How to Add Sparklines in Excel
- How to Add Standard Deviation Bars in Excel
- How to Add Subtotals in Excel
- How to Add Sum in Excel
- How to Add Tags in Excel
- How to Add the Sum of a Column in Excel
- How to Add Tick Boxes in Excel
- How to Add Tick Marks in Excel Graph
- How to Add Total in Excel
- How to Add Trailing Zeros in Excel
- How to Add Trendline in Excel
- How to Add Two Columns in Excel
- How to Add Units in Excel
- How to Add Vertical Line in Excel Graph
- How to Add Yes or No in Excel
- How to Apply Comma Style in Excel
- How to Convert Hours to Minutes in Excel
- How to Convert Seconds to Minutes in Excel
- How to Convert YYYYMMDD to MM DD YYYY in Excel
- How to Create Dummy Variables in Excel
- How to Make a Timeline in Excel
- How to Print Comments in Excel
- How to Remove Comma in Excel
- How to Remove Middle Initial in Excel
- How to Subtract Times in Excel
- How to Sum Hours in Excel
- How to Summation in Excel
- How to Update Excel on Mac
- What an Excellent Day for an Exorcism
Explore other categories
- How To
- Basic Excel Operations
- Excel Formatting and Visual Adjustments
- Excel Formulas and Functions
- Excel Charts and Graphs
- Excel Data Analysis
- Excel Integration and Conversion
- Excel Macros and VBA
- Excel Basics and General Knowledge
- Excel Data Validation and Conditional Formatting
- Excel Printing
- Excel File Management
- Excel Data Manipulation and Transformation
- Excel Linking and Merging
- Excel Cell References and Ranges
- Excel Errors
- Excel Settings
- Excel Versions
- Excel and Other Software
- Excel Add-ins
- Form Controls and User Interaction
- Pivot Tables
- Working with Text
- Excel Tips and Shortcuts
- Excel Training