cant edit format cells

  • Thread starter Thread starter ataur rahman rony
  • Start date Start date
A

ataur rahman rony

i have no columns or rows for date and year.. i just want this as a shortcut...suppose when we write 2001 and press cntrl key and drag-in...then its shown 2001..2002..2003,,,,,,,,,,,


is there is any solution that i write 2001-02,and drag in then its shown 2002-03,2003-04.......ym trying on it.and i edit custom ..but cant do it.how can i do this!!!!
 
If starting year is 2001 then write this in first row (no matter what cell in first row)

=2000+ROW()&"-"&(IF(ROW()+1<10,"0"&ROW()+1,ROW()+1))

Then just drag it down
 
If starting year is 2001 then write this in first row (no matter what cell in first row)



=2000+ROW()&"-"&(IF(ROW()+1<10,"0"&ROW()+1,ROW()+1))



Then just drag it down
Click to expand...

thanx a loot ......its working ....
 
Back
Top