When input in a cell and formatted, the following function could display the following: =NOW()
a) the current year (e.g. 2011)
b) The current month (e.g: "Dec")
c) The number 1
d) The first day of the current month
e) The current miliseconds (e.g: .213)
f) The Date and time (e.g: 12 Dec 2011 11:55:21)