# Excel TODAY - Free Excel Tutorial

## How to Sum if Contains an Asterisk

In our daily life, we may want to sum amounts or sales for a specific period, for example in last N days. Sum numbers in Excel is easy to run, we can apply SUM function. But if we want to sum numbers based on criteria, we can SUMIF or SUMIFS function, compare with SUMIF function,… read more »

## How to Calculate Retirement Date and Remaining Years refer to Birth Date in Excel

Every company has its own police about the retirement date for employees. Suppose employees will be retired from a certain age of 60, how can we calculate the retirement date for everyone base on their birthdays? Actually, there are several functions can calculate the retirement date in excel, you can use them in proper formula,… read more »

## How to Sum If Date is Greater or Less Than in Excel

If we sum for certain conditions, we’ll use the SUMIF function in excel. For example, count the total sales for a period before of after a specified date. This article will help you to do sum for a specified period by SUMIF function. SUMIF Date is Less/Greater than Specified Date in Excel Prepare a table… read more »

## How to Highlight Cell or Row If Date Is In Current Day/Week/Month in Excel

This post will guide you how to highlight cell if date is the current day or is in the current week or month in Excel. How do I highlight row if date is in current week or month with conditional formatting in Excel 2013/2016. Highlight Cell if Date is in Current Day/Week/Month Highlight Row if… read more »

## How to Add the Current Month or Year in a Cell in Excel

This post will guide you how to add the current month or year into a cell or header or footer in your worksheet. How do I insert the current date or time in a cell with a formula in Excel. Add Current Month or Year Using Short Keys Add Current Month or Year Using Formula… read more »

## Conditional Format Dates earlier than or Greater Than Today

This post will guide you how to use conditional formatting to identify dates earlier than or greater than today in Excel. How do I highlight dates greater than or less than today or a certain date with conditional formatting in Excel. How to format cell if cell contains date less than or greater than today… read more »

## Insert Countdown Timer

This post will guide you how to create a countdown timer in an Excel Worksheet. How do I insert a countdown timer in Excel. How to create a countdown timer clock in Excel. Create Countdown Timer Assuming that you want to create a countdown timer until 2020/1/1 in Excel, you can do the following steps:… read more »

## Highlight the Dates if its over a year

This post will guide you how to highlight the dates that are over 1 year in excel. How do I highlight the dates over a year old using conditional formatting feature in excel. How to use conditional formatting to highlight if the dates are over a year in excel. How to highlight cells color when… read more »

## Highlight Rows If Dates Have Passed

This post will guide you how highlight rows if the dates in cells have passed from now in your worksheet. How do I highlight rows if dates have passed with the Conditional Formatting feature in excel. Highlight Rows If Dates Have Passed Assuming that you have a worksheet that have a bunch of columns and… read more »

## Excel TODAY Function

This post will guide you how to use Excel TODAY function with syntax and examples in Microsoft excel. Description The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The serial number is the date-time code used by Excel for date… read more »

## How to Calculate Days, Weeks, Months and Years between Two Dates

This post will teach you how to calculate days, weeks, months and years between two dates in excel. How do I count the number of days, weeks, months and years between 2 dates in excel. Calculate days between two dates If you want to calculate the difference in days between two dates, you can use… read more »

## How to Add / Subtract Days, Months and Years to Date

This post will guide you how to add or subtract a given number of days to a date in excel. How to add or subtract weeks to a date using excel formula. How to add or subtract a certain number of months to a date using excel formula. How to add or subtracts a given… read more »

## How to calculate age from date of birth

This post explains that how to get age from the date of birth in a Cell. How to calculate birthdate to age using formulas in Excel. How to convert the birth of date to age quickly in Excel. Calculate age from date of birth If you have a table that contains birthdate data in a… read more »

## Excel Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Excel IF function  (include multiple If statements in excel formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Microsoft excel. Nested If function Description Nested If Function Syntax Examples of Nested IF function in Excel Nested If Functions(Statements) Order… read more »

Sidebar