Week number in Excel: Avoid Mistakes

Improve your Excel skills by understanding week number calculation. Dive into the WEEKNUM and ISOWEEKNUM functions and their nuances.

Write Months in Any Language in Excel

Discover the trick to displaying months in any language in Excel. Learn how to customize the date format and automate month names in Excel.

Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel

Easily convert dates from the format YYYYMMDD to DD/MM/YYYY in Excel using this simple formula or the Text to Column tool.

Excel Calendar with Automatic Monthly Data Saving 📅

Discover our Excel calendar data saving method. With our user-friendly template, you can effortlessly track and save timesheet updates.

Unlocking the Secrets of Excel’s DATE Function

Learn how to use the DATE function in Excel to effortlessly create dates from values, cell references, or calculations.

Displaying Days in Letters in Excel

This simple tip will improve readability and reduce errors in Excel: add the day of the week in letters to your dates.

Minutes to Hours converter with Excel

Need to convert minutes to hours in Excel? Find out how to do it effortlessly using specific functions and formulas.

Date Picker in Excel

Discover how to use the Date Picker feature in Excel Online to select dates accurately and efficiently. Many situations explained

The TIME function in Excel

Discover the power of the TIME function in Excel. Easily create time values and perform calculations using hours, minutes, and seconds.

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

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 the Number of Days between 2 dates in Excel

Learn how to calculate the number of days between any two dates using in Excel. Easy-to-follow guide with clear explanations and examples

The WEEKDAY function – Secrets and Errors

Master the Excel WEEKDAY function with this easy-to-follow guide. Learn how to use it to determine the day of the week for any date.

Formula to Calculate Quarter with Excel

Discover how to calculate quarters in Excel for any date, whether it's the current, next, or previous quarter, with these formulas.

Separate Date and Time with Power Query

This step-by-step guide will walk you through the process of split your date and time data with Power Query.

Display negative time in Excel

Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.

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 the Previous Monday with Excel

Formula to calculate the previous Monday with Excel, from TODAY or any date.

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.

Calculate the Next Monday with Excel

Master the technique to find the next Monday effortlessly in Excel. Say goodbye to manual counting and hello to efficient date calculations.

Formula First Monday of the month with Excel

Formula to calculate the first Monday of the month with Excel

Calculate Monday 2 weeks ago with Excel

Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.

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 Calculate the Week Number in Excel?

In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.

How to display hours over 24 in Excel?

Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.

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, ...

Time Format in Excel to avoid mistakes

Master time formatting in Excel. Learn how to display dates and times accurately, customize formats, and avoid common mistakes.

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 a date from the week number in Excel

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

Create a weekly calendar with just one formula in Excel

Unlock the potential of Excel by learning how to create a weekly calendar with just one formula. Step-by-step guide 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

DATEDIFF for POWER QUERY

This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)

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.

Change the default Date format in Excel

Learn how to effortlessly change the default date format in Excel using these instructions. Enhance your Excel experience with this guide.

How to Highlight a Birthday Reminder in Excel

This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs

Find Weekend or Weekday in Excel

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

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.

How to Display Tenths, Hundredths with Excel

Learn how to display tenths, hundredths, or thousandths of a second in Excel with a custom time format for accurate analysis.

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

How to make automatic calendar in Excel

This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.