Staff Skills academy+
Home » Courses » Microsoft Excel for Beginners Certification » Module 25 : DATE Formula
Module 25 : DATE Formula
25.1 DATE Formula The DATE function is useful when you need to take three values presented separately and combine them to form a date. The formula for the DATE function is: =DATE(year,month,day) Remember that all three need to be presented as numbers for it to return a date. For example, if you input =DATE(2015,4,6), Excel will return April 6th, 2015. Note that Excel doesn't accept years earlier than 1900. A couple of extra exercises you can try (not in the video) are: To insert the curr...
Lessons
- Module 1 : Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : AVERAGE
- Module 14 : AVERAGEIF
- Module 15 : SUMIF Formula
- Module 16 : IF Formula
- Module 17 : VLOOKUP
- Module 18 : HLOOKUP
- Module 19 : COUNTIF Formula
- Module 20 : COUNTBLANK
- Module 21 : COUNTA Formula
- Module 22 : COUNT Formula
- Module 23 : CONCATENATE
- Module 24 : TRANSPOSE
- Module 25 : DATE Formula
- Module 26 : MONTH Formula
- Module 27 : Pivot Tables
- Module 28 : Pie Charts
- Module 29 : Doughnut Charts
- Module 30 : Line Charts
- Module 31 : Column Charts
- Module 32 : Bar Charts
- Module 33 : Number Formatting
- Module 34 : Create Borders
- Module 35 : Conditional Formatting
- Module 36: Comments
