Tag Archive: INT

Articles sur le thème : INT

Function MOD (Modulo)

The MOD function returns the rest of a division. This function is very useful for a logical test the conditional formatting data validation There is also 2 other functions that could be useful in your test. It’s the functions QUOTIENT or GCD. We will see how to use them at the end of this article. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-mod-modulo/

Split Time and Date

Split Date Time

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 …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/split-time-and-date/