Posts Tagged 'Excel date'
Video: Excel date formulas made easy
This video will show you how to get Excel date formulas of any complexity without actually writing them. Learn how you can find the number of days between two dates, calculate age, add and subtract dates in Excel with your personal date&time formula assistant. Continue reading
Excel date functions - formula examples of DATE, TODAY, etc.
This is the final part of our Excel Date Tutorial that offers an overview of all Excel date functions, explains their basic uses and provides lots of formula examples. Continue reading
Using DATE function in Excel - formula examples to calculate dates
The tutorial explains the syntax and uses of the Excel DATE function and provides formula examples for calculating dates. Continue reading
Excel DATEDIF - calculate difference between two dates in days, weeks, months or years
In this tutorial, you will find a simple explanation of the Excel DATEDIF function and a few formula examples that demonstrate how to compare dates and calculate the difference in days, weeks, months or years. Continue reading
How to add and subtract dates, days, weeks, months and years in Excel
In this tutorial, you will find a variety of useful formulas to add and subtract dates in Excel, such as subtracting two dates, adding days, months and years to a date, and more. Continue reading
How to convert date to year in Excel & calculate age from date of birth
This tutorial explains the syntax and uses of the Excel YEAR function and provides formula examples to extract year from date, convert date to month and year, calculate age from the date of birth and determine leap years. Continue reading
How to convert date to text using Excel TEXT function and no-formula ways
The article explains how to use the Excel TEXT function and a variety of other ways to convert dates to text in Excel. Continue reading
How to convert text to date and number to date in Excel
The tutorial explains how to use Excel functions to convert text to date and how to turn text strings into dates in a non-formula way. You will also learn how to quickly change a number to date format. Continue reading
How to insert dates in Excel - add today's date, auto fill a column with dates
This tutorial demonstrates various ways of entering dates in Excel. See how to insert today's date and current time as static or dynamic values, how to auto populate a column or row with weekdays, and how to auto fill random dates in Excel. Continue reading
How to change date format in Excel and create custom formatting
The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert your dates to another locale. Continue reading
Using IF function in Excel: formulas for numbers, text, dates, blank cells
In this tutorial, we are going to learn the syntax and common usages of Excel IF function as well as discuss a few formula examples for text, dates and numbers that will hopefully prove helpful both to beginners and experienced Excel users. Continue reading
How to conditionally format dates and time in Excel - built-in rules and formulas
See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading
