Posts Tagged 'Excel date'
How to sort by date in Excel: in chronological order, by month, auto sort
Excel's built-in sort options are powerful and effective tools, but they do not always work correctly when it comes to sorting dates. This tutorial will teach you a few useful tricks to arrange Excel spreadsheets by date in a meaningful way without messing up your data. Continue reading
How to calculate days since or until date in Excel
Are you stuck with calculating how many days there are since a certain date or until date? This tutorial will teach you an easy way to add and subtract days from date in Excel. With our formulas you can quickly calculate 90 days from date, 45 days before date, and count whatever number of days you need. Continue reading
Calculate and highlight 90/60/30 days from or before today in Excel
Are you looking to calculate the expiration date that is exactly 90 days from now? Or you need to know the date that occurred 60 days before today? Whatever your task is, this tutorial will teach you how to make your own date calculator in Excel in under 5 minutes. Continue reading
How to calculate days between dates in Excel
Are you wondering how many days are between two dates? Maybe, you need to know the number of days between today and some specific date in the past or future? Or, you just want to count working days between two dates? Whatever your task is, one of the below examples will certainly provide the solution. Continue reading
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 TODAY function to insert today's date and more
You want to put today's date in some cell? Or you wish to highlight the current date in your Excel calendar? Or you'd like to find the date closest to today? All this can be done by using the Excel TODAY function and this tutorial will teach you how. Continue reading
How to calculate age in Excel: from date of birth, between two dates, and more
There is no special function to calculate age in Excel, however there exist a few different ways to convert date of birth to age. This tutorial will explain the advantages and drawbacks of each way, shows how make a perfect age calculation formula in Excel and tweak it for solving some specific tasks. Continue reading
How to create calendar in Excel (drop-down and printable)
The tutorial shows how to insert a drop-down calendar in Excel, and how to quickly create a printable calendar based on a template. 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
Using MONTH and EOMONTH functions in Excel - formula examples
The tutorial explains the nuts and bolts of Excel MONTH and EOMONTH functions. You will find an array of formula examples demonstrating how to extract month from date in Excel, get the first and last day of the month, convert month name to number and more. Continue reading
WEEKDAY, DAY and other functions to calculate days in Excel
In this tutorial, you will find lots of formula examples demonstrating the use of WEEKDAY, DAY and DAYS functions in Excel. See how to return a day of week from date, get the number of days in the year, find how many days are between two dates and more. Continue reading
How to convert date to text in Excel with TEXT function and without formulas
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
