• Calculate date range (Excel 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Calculate date range (Excel 2000)

    Author
    Topic
    WSnstephens
    AskWoody Lounger
    October 21, 2003 at 10:26 pm #395366

    How do I calculate date ranges? (The “help” answers were not very clear.) For example: I have the date (10/21/03) entered and I want the next column to show a date 7 years from that date (10/21/10). What formula should I use?

    Reply | Quote
    Viewing 5 reply threads
    Author
    Replies
    • WSsdckapr
      AskWoody Lounger
      October 21, 2003 at 10:39 pm #732762

      If your date is in A1 you can use the formula:

      =DATE(YEAR(A1)+7,MONTH(A1), DAY(A1))

      Steve

      Reply | Quote
    • WSsdckapr
      AskWoody Lounger
      October 21, 2003 at 10:39 pm #732763

      If your date is in A1 you can use the formula:

      =DATE(YEAR(A1)+7,MONTH(A1), DAY(A1))

      Steve

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      October 21, 2003 at 10:40 pm #732766

      Say that you have a date in cell A1.

      To get the date 7 days later: =A1+7 or =DATE(YEAR(A1),MONTH(A1),DAY(A1)+7)

      To get the date 7 months later: =DATE(YEAR(A1),MONTH(A1)+7,DAY(A1))

      To get the date 7 years later: =DATE(YEAR(A1)+7,MONTH(A1),DAY(A1))

      Excel automatically adjusts for “overflow” in the day or month.

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      October 21, 2003 at 10:40 pm #732767

      Say that you have a date in cell A1.

      To get the date 7 days later: =A1+7 or =DATE(YEAR(A1),MONTH(A1),DAY(A1)+7)

      To get the date 7 months later: =DATE(YEAR(A1),MONTH(A1)+7,DAY(A1))

      To get the date 7 years later: =DATE(YEAR(A1)+7,MONTH(A1),DAY(A1))

      Excel automatically adjusts for “overflow” in the day or month.

      Reply | Quote
    • WSchipshot
      AskWoody Lounger
      October 22, 2003 at 11:49 am #733149

      Two of my favorite functions that were included in Excel 97’s Analysis Toolpak are EDATE and EOMONTH. These may be part of Excel 2000’s core set of functions. =EDATE(date,7) would give you the same date 7 months later. =EOMONTH(date,7) would move you ahead seven months and give you the last day of that month. EOMONTH is particularly useful for setting up a series of month end dates.

      Reply | Quote
      • WSHansV
        AskWoody Lounger
        October 22, 2003 at 1:29 pm #733253

        EDATE and EOMONTH are still part of the Analysis Toolpak in Excel 2002.

        There is no equivalent EYEAR function. To get the date seven years from the date in A1 (as in the original question in this thread), one can use =EDATE(A1,7*12)

        Reply | Quote
      • WSHansV
        AskWoody Lounger
        October 22, 2003 at 1:29 pm #733254

        EDATE and EOMONTH are still part of the Analysis Toolpak in Excel 2002.

        There is no equivalent EYEAR function. To get the date seven years from the date in A1 (as in the original question in this thread), one can use =EDATE(A1,7*12)

        Reply | Quote
    • WSchipshot
      AskWoody Lounger
      October 22, 2003 at 11:49 am #733153

      Two of my favorite functions that were included in Excel 97’s Analysis Toolpak are EDATE and EOMONTH. These may be part of Excel 2000’s core set of functions. =EDATE(date,7) would give you the same date 7 months later. =EOMONTH(date,7) would move you ahead seven months and give you the last day of that month. EOMONTH is particularly useful for setting up a series of month end dates.

      Reply | Quote
    Viewing 5 reply threads
    Reply To: Calculate date range (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.