+ Reply to Thread
Results 1 to 3 of 3

Add Years?

  1. #1
    Registered User
    Join Date
    06-08-2007
    Location
    Scotland...Lagos...Moscow!
    Posts
    57

    Add Years?

    Can anyone help with what is no doubt simple formula, but I just can't get the syntax correct for it.

    In column A I have numbers 1 to 10 representing years.
    In column B I have dates in the format 01/01/2007

    I need to take the number in A and add it as years to column B, therefore keeping both the day and month the same.

    TIA

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486
    =date(year(b1)+a1,month(b1),day(b1))

  3. #3
    Registered User
    Join Date
    06-08-2007
    Location
    Scotland...Lagos...Moscow!
    Posts
    57
    Quote Originally Posted by davesexcel
    =date(year(b1)+a1,month(b1),day(b1))
    Thanks - so easy when you see it like that; I could kick myself!!

+ Reply to Thread

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