Results 1 to 11 of 11

Excel =Date and Leap Years

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    75

    Excel =Date and Leap Years

    Hello,

    I am looking to add years and months to a date to obtain some final date. Like an expiration date.

    However, I need it to factor in leap years which excel does not seem to do using the Date function unless I'm using it incorrectly.

    I've created a sample of what I'm looking for using the expiration date example. Excel simply seems to add year to year, month to month, without considering leap years in between.

    The format I am using is along the lines of:

    =DATE(YEAR(A1+B1),MONTH(A1+B2),DAY(A1)) where A1 is the starting date and B1 and B2 are years and months respectively.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1