Fill dates

eg. Fill by months: i.e. you want a range of cells to be 2006/12/15, 2007/01/15, 2007/02/15 …

  1. goto your desired start cell (A2) and enter =date(2006,12,15)
  2. goto next cell where you wish to increment =date(year(a2),month(a2)+1,day(a2))
  3. In next cell which is in sequence copy the formula and paste
datefill.txt · Last modified: 2014/10/26 01:52 (external edit)
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0