First day – Last day in Excel
This article is a glossary of all the Excel functions to return the first day or the last day of the Month, the Quarter or the Year
TODAY
TODAY and NOW function in Excel
The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between 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.
Function DATE – YEAR – MONTH – DAY
The function DATE is very useful to create your custom dates. This article will explain you how the function works
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (46)
- Dynamic Arrays (8)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (29)
- Finance (5)
- Free Excel Tutorial for beginners (32)
- Function (2)
- Intermediate Excel Skills: Tutorials and Articles (24)
- Lookup functions (14)
- Manage data (23)
- Maps and GPS (5)
- Pivot Table (7)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (18)
- Tips and Tricks (23)
