Excel DATE formula | EASY Excel Tutorial |

How to use Excel DATE formula

	Day	Month	Year	Date
	25	12	99	12/25/99	=DATE(E4,D4,C4)
	25	12	99	25-Dec-99	=DATE(E5,D5,C5)
	33	12	99	January 2, 2000	=DATE(E6,D6,C6)
What Does It Do?
This function creates a real date by using three normal numbers typed into separate cells.
Syntax
=DATE(year,month,day)
Formatting
The result will normally be displayed in the dd/mm/yy format.
By using the Format,Cells,Number,Date command the format can be changed.

Excel COUNTIF | How to use the Excel COUNTIF function | Best Excel Tutorial

Excel COUNTIF examples

	Item	Date	Cost
	Brakes	1-Jan-98	80
	Tyres	10-May-98	25
	Brakes	1-Feb-98	80
	Service	1-Mar-98	150
	Service	5-Jan-98	300
	Window	1-Jun-98	50
	Tyres	1-Apr-98	200
	Tyres	1-Mar-98	100
	Clutch	1-May-98	250
How many Brake Shoes Have been bought.				2	=COUNTIF(C4:C12,"Brakes")
How many Tyres have been bought.				3	=COUNTIF(C4:C12,"Tyres")
How many items cost £100 or above.				5	=COUNTIF(E4:E12,">=100")
Type the name of the item to count.			service	2	=COUNTIF(C4:C12,E18)
What Does It Do ?
This function counts the number of items which match criteria set by the user.
Syntax
=COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched)
The criteria can be typed in any of the  following ways.
To match a specific number type the number, such as =COUNTIF(A1:A5,100)
To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello")
To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100")
Formatting
No special formatting is needed.