Saturday, 3 September 2016

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.