Date in Excel

Learn how to work with dates in Excel through practical guides, tutorials, and troubleshooting tips. Discover the best methods to organize, analyze, and manage time-based data in your spreadsheets, from essential formatting to advanced calculations.

How to display Months in Letters in Excel?

Learn the simple trick to display months in letters instead of numbers in your Excel date. Clear instructions and examples

Calculate Monday Previous Week with Excel

Learn how to find the date of the previous Monday using Excel. Streamline your scheduling and data analysis with this handy formula.

Calculate Monday in 2 weeks with Excel

Learn how to find the Monday in 2 weeks in Excel effortlessly. Boost efficiency and streamline workflows with this easy-to-use formula.

Formula First Monday of the month with Excel

Formula to calculate the first Monday of the month with Excel

Convert a Text Date to a Number Date

Learn how to convert a text date, like '1 January 2023', to a number date format using Excel. Easily convert text dates to numerical values.

Highlight the Date outside the deadline in Excel

How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.

Add Days Excluding the Weekend in Excel

How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.

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.

Calculate any Day of the Week Using These Excel Formulas

All the formulas to calculate any day in a week, like the first Monday of the month, the last one, the next Tuesday, ...

Change the Color of Weekends in Excel 🗓️🎨

Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.

Calculate Seniority in Excel

Calculate seniority is an easy task with Excel when you use the appropriate function.

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.

Calculate Public holidays with Excel 📆

Discover how Excel can make it easy to calculate public holidays. Learn simple formulas to automate the process and never miss a holiday again.

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.

Title with Text and Date in the same cell

Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.

Date Format in Excel

Discover how to customize your date format in Excel easily by changing the day, month, or year. There are many examples.

Excel Split Date and Time

Discover how to separate date and time in Excel with ease. Use the INT and subtraction functions to extract the desired values.

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

Date in Excel

Categories

Date in Excel