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.

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

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.

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

Formula First Monday of the month with Excel

Formula to calculate the first Monday of the month with Excel

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.

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

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