In A1 enter:
1/1/2007
In A2 enter:
=A1+1
copy A2 to A3 thru A365
--
Gary''s Student - gsnu200757


"balu" wrote:

dear sir,
is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07
code will be coded from an access form to perform on excel