ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   dates and formats (https://www.excelbanter.com/new-users-excel/195654-dates-formats.html)

Jenny dev

dates and formats
 
I am trying on one colum to have the dates 01/07/2008 (dd/mm/yy) right until
30/06/2008 but l just cannot get it to do this. What am l doing wrong. have
typed dates in 2 cells the hage highlighted both boexs until + appears and
drag down this stops at month 12. Please can some one assits me in this
beofre l go crazy
--
jd

Max

dates and formats
 
Enter an unambiguous startdate in say, A1: 01-Jul-2008. Just drag A1 down as
far as required. It'll increment one day per row. Then only format the col in
the date format that you want to taste.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"Jenny dev" wrote:
I am trying on one colum to have the dates 01/07/2008 (dd/mm/yy) right until
30/06/2008 but l just cannot get it to do this. What am l doing wrong. have
typed dates in 2 cells the hage highlighted both boexs until + appears and
drag down this stops at month 12. Please can some one assits me in this
beofre l go crazy
--
jd



All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com