Results 1 to 7 of 7

retrieve number of years and months from cells yyyymmdd

Threaded View

  1. 10-20-2020, 02:38 PM #1
    Akika
    Akika is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. Require a formula for displaying total number of months as years with months (YY,MM)
    By jayatjay in forum Excel Formulas & Functions
    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. Formula for- (Calculate the number of months between two dates(separate Years/months colum
    By xcfeng95 in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1