How to Calculate the Number of Days Between Two Dates in Excel
Subtract two dates, add 1 when both days count, or use NETWORKDAYS to skip weekends and holidays. Then practise on a free invoice exercise.
Difference between 2 dates
The DATEDIF function in Excel
Want to calculate date differences? Learn how to use the DATEDIF function in Excel to determine the age between dates accurately.
Categories
- AI & Excel (3)
- Conditional (13)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (12)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (13)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (27)
- Text functions (21)
- Tips and Tricks (22)
