skip to main | skip to sidebar

Software Development Tidbits

Notes, commentary, and other drivel on all aspects of software development, with the occasional off topic bits thrown in.

Thursday, November 24, 2011

Formula to Increment Month in Excel

Given A1 contains the starting date:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
increments the month.

References

Adding/Subtracting n Month(s) To/From a Date, ozgrid.com
Excel forumula to add a month, Computing.Net
Posted by Caleb at 12:49 PM
Labels: Software
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Blog Archive

  • ►  2012 (2)
    • ►  June (2)
  • ▼  2011 (1)
    • ▼  November (1)
      • Formula to Increment Month in Excel
  • ►  2010 (9)
    • ►  December (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2009 (34)
    • ►  November (2)
    • ►  October (3)
    • ►  September (4)
    • ►  August (1)
    • ►  July (4)
    • ►  June (3)
    • ►  May (1)
    • ►  March (3)
    • ►  February (5)
    • ►  January (8)
  • ►  2008 (16)
    • ►  December (6)
    • ►  November (10)

Labels

  • Admin (1)
  • Blog (1)
  • Build (1)
  • Business (1)
  • C++ (3)
  • C++ Libraries (1)
  • Command Line (2)
  • Concurrency (1)
  • Configuration (2)
  • Construction (1)
  • CSS (1)
  • Data Structure (1)
  • Database (2)
  • Design (2)
  • Design Pattern (1)
  • Distribution (1)
  • Documentation (2)
  • Frameworks (1)
  • Games (1)
  • Graphics (2)
  • GUI (2)
  • HTML (1)
  • Java (4)
  • Latex (2)
  • Libraries (2)
  • Links (2)
  • Linux (1)
  • Management (4)
  • Math (1)
  • Movies (1)
  • Profession (4)
  • Programming (1)
  • Python (8)
  • Python Libraries (2)
  • Quote (1)
  • Scripts (3)
  • SD Video (1)
  • Security (4)
  • Software (16)
  • Software Engineering (6)
  • Standards (1)
  • Swing (1)
  • Tools (3)
  • Vim (3)
  • Web (12)
  • Windows (3)
  • XHTML (1)