Dates

[pheobis]

Is there a way i can automatically set cells up so they say dates in a corresponding order..for example

A2 (Aug 1st, 2007) B2 (Aug 2nd, 2007) and so on....

 

[sykes]

Can't you just format the cells in question, and then use the fill handle for this?

 

[Norie]

I think you'll find if you put a date in a cell and the drag across columns the date will increment like that.

Would that do, or is there more to what you want?

 

[Scott Huish]

If you are looking to set it up so that it automatically fills in for whatever the current month is:

In A2:
=IF(COLUMN(A1)>DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)),"",(TODAY()-DAY(TODAY()))+COLUMN(A1))

Copy across to AE2

or if you have the Analysis Toolpak installed:
=IF(COLUMN(A1)>DAY(EOMONTH(TODAY(),0)),"",EOMONTH(TODAY(),-1)+COLUMN(A1))
Format as date.