Date in Excel

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

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

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

Formula to calculate the first Monday of the month with Excel

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.

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

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

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

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 with conditional formatting. Quick and easy with this step-by-step guide.

Formula to calculate a date according to the week number. The result is not the same according to the iso week number system

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

Want to calculate date differences? Learn how to use the DATEDIF function in Excel to determine the age between dates accurately.

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

Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.

The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.

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

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

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

The function DATE is very useful to create your custom dates. This article will explain you how the function works