date formula

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

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

Learn how to find the date of the previous Monday using Excel. Streamline your scheduling and data analysis with this handy formula.

Learn how to find the Monday in 2 weeks in Excel effortlessly. Boost efficiency and streamline workflows with this easy-to-use formula.

Formula to calculate the first Monday of the month with Excel

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.

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

All the formulas to calculate any day in a week, like the first Monday of the month, the last one, the next Tuesday, ...

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

The function DATE is very useful to create your custom dates. This article will explain you how the function works