ExcelBanter - Changing Dates in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing Dates in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/161749-changing-dates-excel.html)

Mattie

Changing Dates in Excel

I have an invoice that I have created and it shows payments broken down by
week.
DESCRIPTION DATE
11 SCREENS 10/5/2007
11 SCREENS 10/12/2007
11 SCREENS 10/19/2007
11 SCREENS 10/26/2007

I would like to have the dates automatically generate and reflect to correct
dates by month. Is this possible?

Rich[_2_]

Changing Dates in Excel

format the cells how you want them

hightlight the row. goto format then custom

in the top box type MMM DD YY

wll give you the results by mth first

"mattie" wrote:

I have an invoice that I have created and it shows payments broken down by
week.
DESCRIPTION DATE
11 SCREENS 10/5/2007
11 SCREENS 10/12/2007
11 SCREENS 10/19/2007
11 SCREENS 10/26/2007

I would like to have the dates automatically generate and reflect to correct
dates by month. Is this possible?

All times are GMT +1. The time now is 09:13 AM.