Power Query Split Date and Time

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

Excel negative hours

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

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

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

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

Calculate the Next Monday with Excel

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

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.

Calendar in Excel with Data Saving

Calendar with saving of the data created with Excel. Download this file to follow the activity of your employees

Convert a Text Date to Numeric Date

How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.

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.

How to display hours over 24

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.

Formulas for calculating the days of the week

In this article, you will find all the formulas that allow you to calculate the days of the week; like the next Monday, Tuesday, Wednesday, …. Formula to calculate the First Monday of the month The following formula returns the first Monday of the current month based on today's date. =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+7-1) Formula to calculate the last Monday […]

Calculate a date from the week number

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