+ Reply to Thread
Results 1 to 7 of 7

retrieve number of years and months from cells yyyymmdd

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    canada
    MS-Off Ver
    2016
    Posts
    43

    retrieve number of years and months from cells yyyymmdd

    hi
    pls help
    in excel sheet, I got a column "date updated" format yyyymmdd
    and another column status (low, average, complex )
    I need to add 3 more columns the number of years, months and days calculated from column date updated when compared with year 2020.
    Last edited by Akika; 10-20-2020 at 02:49 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: retrieve number of years and months from cells yyyymmdd

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: retrieve number of years and months from cells yyyymmdd

    ...compared with year 2020
    When in 2020?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    10-09-2018
    Location
    canada
    MS-Off Ver
    2016
    Posts
    43

    Re: retrieve number of years and months from cells yyyymmdd

    missed out the sample file... pfa
    Attached Files Attached Files

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: retrieve number of years and months from cells yyyymmdd

    See the updated sample.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-09-2018
    Location
    canada
    MS-Off Ver
    2016
    Posts
    43

    Re: retrieve number of years and months from cells yyyymmdd

    Thxs TMS..

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: retrieve number of years and months from cells yyyymmdd

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split number of months from years
    By ardhuru in forum Excel General
    Replies: 10
    Last Post: 07-05-2017, 10:45 AM
  2. [SOLVED] Convert number to years, months and days
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2015, 01:47 PM
  3. Replies: 2
    Last Post: 07-22-2014, 02:15 AM
  4. Convert the number of weeks into years and months
    By Pickygame in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2014, 12:19 PM
  5. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  6. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  7. [SOLVED] how do I convert a number to number of years, months and days
    By because in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

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