how to organize a colunm

Copper Contributor

Hi. I would like to know how to organize a column in Excel but by day of every month, for example 01/01/1999, 02/01/2001

1 Reply
Your request is too vague to allow a good response to be made. Does "organize a column" mean that you want a formula in the column that will calculate successive dates? Based on your mere two example dates, should each row be 25 months apart (if your example dates are mm/dd/yyyy), or two years and one day apart (if your example dates are dd/mm/yyyy), or something else?

Note that if you click the "Open full text editor" link, you can imbed an image, or attach an Excel file, or build a simple table structure to contain a more complete example.