Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

date formatting excel

  • Home
  •   »  
  • date formatting excel
Excel
dates in excel

Find the Difference Between Two DateTimes in Excel

Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding

Excel
date vs. datedif function

DATE vs. DATEDIF Functions

It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a

Excel Date functions Excel Functions
DATE – Excel Function

DATE – Excel Function

What it does: The DATE() formula returns the serial number that represents a particular date. Plain English: This formula

Excel Date functions Excel Functions
DAYS – Excel Function

DAYS – Excel Function

What it does: The DAYS() function returns the number of days in between two dates Plain English: In your data cleaning

  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com