Tag Archive: Date

Articles sur le thème : Date

How to make automatic calendar in Excel

Creating a new calendar each month is a waste of time, but many people do as they think they need to rebuild it to get correct weekends and public holidays. But in fact, with few formulas, 2 conditional formatting rules, 1 dropdown list and 5 lines of VBA code, you can create an automatic calendar. …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/how-to-make-automatic-calendar-in-excel/

Function DATE - YEAR - MONTH - DAY

Presentation of DAY, MONTH, YEAR The Functions YEAR, MONTH and DAY are very simple to understand. They extract each part of a date. DAY extracts the day of a date MONTH extracts the day of a date YEAR extracts the day of a date Individually, these functions do not interesting but used with the DATE function, they are …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-date-year-month-day/

How to use the contain of cells in Excel?

In Excel, it's very easy to use the contain of cells. You just have to call the reference of a cell to reuse its value in as data or in a formula. What is the reference of a cell? In Excel, a cell is often called by its references. In other word, the intersection of a …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/use-contain-cells-excel/

The correct value of the week number

The function WEEKNUM In Excel, to return the week number of a date you have the function WEEKNUM. =WEEKNUM(Date) Easy ? Sure ? 🙄🤔 Well in fact, it's not so simple. It depends if you are in USA or in another country. The rule of calculation for the week is different between the USA and the …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/correct-value-week-number/