This step-by-step guide will walk you through the process of split your date and time data with Power Query.
Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.
Formula to calculate Monday for the previous week with Excel, from TODAY or any date.
Formula to calculate the previous Monday with Excel, from TODAY or any date.
Formula to calculate Monday in 2 weeks with Excel, from TODAY or any date.
Formula to calculate the next Monday with Excel, from TODAY or any date.
Formula to calculate the first Monday of the month with Excel
Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.
Calendar with saving of the data created with Excel. Download this file to follow the activity of your employees
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.
How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.
Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.
With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.
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 […]
Formula to calculate a date according to the week number. The result is not the same according to the iso week number system