1. Get the day of the Week from Date
where cell A1 contains the date 01/12/2009 the formula
= Text(A1,”ddd”) will give Tue
= Text(A1,”dddd”) will give Tuesday
2. Count Occurences in a Column
Sometimes you may wish to count the number of occurences of a number or text in a sequence of cells.
Using our example we see that
=CountIf(A1:A10,5)
will give [...]