Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Computing Dates (Office XP)

    Can anyone tell me how I would compute a date in the future? For example, Column A has a date (2/18/02), Column B represents the number of months: "24" (as in 24 months), I would like column C to be the result in a date format (2/18/04). Anyone know how to do this?
    Thanks for your help.
    Louise

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Computing Dates (Office XP)

    in column c:

    =DATE(year(a1),month(a1)+B1,day(a1))
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Computing Dates (Office XP)

    Thank you very much! Works great!
    Louise

Posting Permissions

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