Results 1 to 13 of 13

How to extract last 2 digits from date year in next column?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    How to extract last 2 digits from date year in next column?

    Hi friends,
    I want to extract the last 2 digits of date year in next column. For ex. suppose the date is in column O then the output should be in column P.

    I don’t want to change the date each year but I want to change the number in column P each year. 10 to 11, 11 to 12, 12 to 13 and so on each year.

    If there is a remark in column Z ‘Left’ then no change in the number in column P.
    Thanking you,
    Attached Files Attached Files
    Sincerely,

    mso3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Year or Month only from a cell with date and time
    By djaurit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2013, 04:03 PM
  2. [SOLVED] Extract Text from String then Convert to a Date (Month/Year)
    By sgrey24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2013, 06:11 PM
  3. Extract and manipulate Last 2 Digits form Date/Time
    By NSTurk725 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2010, 03:49 PM
  4. extract date info, disregard year
    By koticphreak in forum Excel General
    Replies: 2
    Last Post: 04-10-2009, 01:49 PM
  5. extract year from the date in a cell
    By DKY in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-17-2006, 03:10 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