Formulas

When you input the date time in excel, you always need to calculate the date-time between 2 dates. This article will tell you how to calculate the time, hours, days, months, and years between 2 dates in Microsoft excel with or without Excel functions.

When you import text data from a .csv file or a database into excel, you may find the imported date column value is saved as text format. But you need to change the text value to excel date format to process them using the excel functions. This article will tell you how to convert text …

Excel Convert Text To Date Example Read More »

When you write an excel formula, you always need to use excel functions in the formula. But there are hundreds of excel functions, how to select which one to use? how to insert function in excel formula? This article will tell you how to do it.

In this article, I will tell you how to apply an excel formula to the entire column quickly. That means you input the formula in one cell of the column, then it can be applied to all the other cells in the column.