Enter
01/01/01 Into A1 And 01/02/01 Into A3 You could custom format those 2 cells to display exactly what you wish. Then, select A1 to A4. Click on the fill handle of that 4 cell selection, and copy down as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "viper" wrote in message ... I would like to know how to put a date in this format 01/01/01 on A1 and I would like excel to to change the date on A3 to 01/02/01 and so on and so forth. how do I do it. for a whole year or two. |
how do I set dates every 3 cell for whole year in excel
I would like to know how to put a date in this format 01/01/01 on A1 and I
would like excel to to change the date on A3 to 01/02/01 and so on and so forth. how do I do it. for a whole year or two. |
All times are GMT +1. The time now is 11:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com