Differences

This shows you the differences between two versions of the page.

Link to this comparison view

datefill [2014/10/26 01:52] (current)
Line 1: Line 1:
 +==== 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 ...
 +
 +  - goto your desired start cell (A2) and enter //​=date(2006,​12,​15)//​
 +  - goto next cell where you wish to increment //​=date(year(a2),​month(a2)+1,​day(a2))//​
 +  - 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