Question 1 :
You can enter A1:A30000 in the Names box, left of the formula bar, to select the range.

Then type the formula in the formula bar, press and hold the Ctrl key, then press Enter.

Question 2 :
You have to enter the entire date (31/12/2013) in the first cell , format as needed, then drag down

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post