Day of week and Day of year

[CornCrib]

Good Morning, I'm new to this forum, but just viewing I can say I like it already.
My question...... I have a spreadsheet that I need to keep sales and other information by day..ie.Sun,Mon,Tue, etc. but I also need to know that Sun (for example) is also Jan 23rd. Is there a way that I can automatically enter this information in headings, or do I have to do it manually. In other words, it would be great if I could enter Jan 1st into a cell and then EXCEL would populate the next 364 cells with the dates thru Dec. 31st?

I'm not a programmer, and would consider myself a moderate user.

Thanks for any and all help.
gene

[Richard Buttrey]

Hi,

Just enter 1/1/2011 in say A1 and in A2 enter =A1+1 and copy this down 364 rows.

Regards