# Articles sur le thème : Date format

## Split Time and Date

If you have in a cell a time and a date (like the use of the function NOW) it’s easy to split them in 2 different cells. Split the date Let’s start from the following document where you have in column A data with date and time We want to split The date in column …

## Fill Series

The fill handle is very useful to copy formulas as you know but also, you can fill series of number or date. Look at the following tutorials to see what you can do. Fill series of numbers When you have to create a list of number, it is not necessary to create a formula or to …

## Calculation of tenths, hundredths and thousandths with Excel

3 Thousandths 😱😱😱 Looking at results of speed skating in the Olympic winter games of 2014, the gap between the first and second of the 1500m race was only 3 thousandths. Separate athletes with thousandth is extremely unusual and this give me the idea to calculate what represent 0.003 after 1500m race. With Excel, it’s …

## Date format

It’s important to understand how Date and Time are managed in Excel to custom their format. What is a date in Excel? Display number and not a Date. It’s normal😉 In Excel, it is possible that a cell doesn’t display a date as you expect but a number such as 42370. For a lot of …

## Title with date in Excel

Function TEXT converts any number into text and keep the specific number format. Presentation of the function TEXT TEXT function converts any number data into a text format according the parameters you give to the function. TEXT function has two parameters the number the format to apply Problem to solve Let’s take an example with …

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

## NOW & TODAY

The functions TODAY and NOW are two extremely important functions. They allow you to create dynamic workbooks using the system date on your computer. We will use these functions to create workbooks such as Automatic calendar Worker timesheet Follow-up of supplier payments Delivery delays … Presentation of the functions To view the current day, use …

## 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 …