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.
date formula
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 any day of the week with formula
All formulas that allow you to calculate the following or previous days such as Monday, Tuesday, Wednesday, ...
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
