## How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video

How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video Bottom line: Learn how to create month to date (MTD) calculations in your pivot tables for month-over-month, quarter-over-quarter, or year-over-year comparisons. Skill level: Intermediate Task: The boss wants to see a report that shows the numbers for the first 15 days […]

## Excel Formula To Calculate Age in Years Months and Days On a Specific or Current Date

Excel Formula To Calculate Age in Years Months and Days On a Specific or Current Date Hello Friends, As promised in this article I will show you the process to calculate the exact age in Days, Months and Years from two given dates be it current date or any specific date. I will use DATEDIF […]

## How to use DATE Function | Microsoft Excel

How to use DATE Function | Microsoft Excel DATE Function will return you a sequential number which comprises Year, Month and Day and defines a specific date. Syntax of DATE Function =DATE(year,month,day) Arguments of DATE Function year: it is a year of the date you want. As per the system dates, it counts the year from […]

## Changing Date Formats in Excel

Changing Date Formats in Excel No matter how you display it, a date is a date. Different Date Formats 1/15/2015 Thursday, January 15, 2015 1/15 01/15/15 January 15, 2015 15-Jan-2015 J-15 So why would you want to change the look of a date and how would you go about doing it? Well Excel is a […]

## Changing Date Formats in Excel

Changing Date Formats in Excel No matter how you display it, a date is a date. Different Date Formats 1/15/2015 Thursday, January 15, 2015 1/15 01/15/15 January 15, 2015 15-Jan-2015 J-15 So why would you want to change the look of a date and how would you go about doing it? Well Excel is a […]