Displaying Date and Time in the Same Cell
How to display date and time together in the same cell using custom number formatting. This tutorial explains you the steps
Custom Date
How to build your dynamic dates in Excel
With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.
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
Calculate Public holidays with Excel
How to calculate the public holidays in Excel? This article will present many formulae to calculate those dates according to the year.
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)
