Excel Forum
Similar Content
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
Highlight Rows that Meet a Certain Condition in Excel
Tutorial: In this tutorial I am going to cover how to highlight rows that meet a certain condition. ...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...

Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

See how to:
1.Dates in Excel are whole numbers - called serial numbers. Example: 1, 2, 3, 40900, 40901.
2.The numbers represent the number of days since Dec 31, 1899.
3.The first day in Excel's world is Jan 1, 1900
4.Dates Show Date Number Format
5.Custom Date Number Format
6.Number of days invoice past due
7.Loan Maturity Date
8.Project finish date
9.Number of days alive
10.Last day in this month, last month, next month
11.TODAY function, NOW function
12.DAY function, MONTH function, YEAR function
13.DATE function
14.EDATE function
15.EOMONTH function
16.Calculate days in current month
17.WORKDAY function to calculate future date
18.NETWORKDAYS function to calculate working days between two dates
19.Fill Weekdays only with Smart Tag
20.Formula to increment dates
21.TEXT function to make date labels

Got a Question? Ask it Here in the Forum.