Displaying Days in Letters in Excel

Customize your date format in Excel to display days in letters and dates. Avoid errors and save time with this helpful feature.

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

=TIME(Hours,Minutes,Seconds) Times is necessarily a decimal value In Excel, hours are always a fraction of a day. So it is necessarily decimal numbers (ALWAYS). This rule is fundamental to avoid mistakes in calculation and display. For instance, in the following picture, we have the value 0.5 in a cell. If we change the format number to the Time format, we have 12 hours this time. This is logical because 12 hours is the middle of the day, so 0.5 day 😉 Most people use integer numbers to write their time values. It's a fact that writing a time in Excel is not easy because you must use the symbol colon ( : ), like 12:00:00. Many people prefer to write the value 12 (an integer number). But when you apply a Time format to an integer number, the only result you have it's 00:00:00 😱😱😱 TIME function to transform your […]

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

Write Months in Excel in a Foreign Language

Learn how to write automatically your Months in any Foreign Language in the world. This step-by-step guide will show you the trick.

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

=WEEKDAY(Date,Localization) How to use the WEEKDAY function The WEEKDAY function operates with minimal arguments, just a date =WEEKDAY(A1) Yet the returned result may pose confusion. The 13/11/2023 is a Monday and the WEEKDAY function returns 2; WHY? The function, developed by Microsoft, an American company, reflects the U.S. convention where the week starts on Sunday, making Monday the second day. This is why, if you don't use the same US convention for the first day of the week, the results of the WEEKDAY function can insert errors in your report. Explanation of the second argument The second parameter is optional but very useful if you are NOT in USA or Canada. While Monday is the default first day for most countries globally, specifying this argument ensures accurate calendar settings. You can set values for the second argument as follows: The screenshot displays the different results returned for the same date […]

Formula to Calculate Quarter with Excel

Easily determine the quarter for any date with these Excel formulas. Learn how to calculate quarters in Excel in just a few steps.

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.

Save Data Automatically with Excel Calendar

Download our automated monthly calendar to streamline your scheduling! Ideal for busy professionals, students, organization

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.

Convert YYYYMMDD to DD/MM/YYYY with Excel

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step

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

All formulas to calculate any day

All formulas that allow you to calculate the following or previous days such as Monday, Tuesday, Wednesday, ...

Create a weekly calendar with just one formula in Excel

Generate a dynamic weekly calendar in Excel with this single powerful formula SEQUENCE. Easy and efficient

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.

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.

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.

Calculation of tenths, hundredths and thousandths with Excel

It's not easy to make calculation with time in Excel, especially if you want to do calculation for tenths, hundredths and thousandths.In this article, you will have all the explanations to do such calculation.

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.

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

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.