+ Reply to Thread
Results 1 to 4 of 4

Get year from Number

Hybrid View

  1. 02-04-2018, 09:41 AM #1
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    701

    Get year from Number

    Hi friends,

    I want to convert a number to year, ex:

    A1 = 2018
    A2 = Date(Year(A1), 1, 1)


    But I am getting the wrong date = 01/01/1905


    Please send me correct formula
    Reply With QuoteRegister To Reply
  2. 02-04-2018, 09:48 AM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Get year from Number

    That would just be
    =DATE(A1,1,1)
    Reply With QuoteRegister To Reply
  3. 02-04-2018, 09:52 AM #3
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    701

    Re: Get year from Number

    Thank u Jonmo1
    Reply With QuoteRegister To Reply
  4. 02-04-2018, 10:08 AM #4
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Get year from Number

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. How to match donor data from year to year (ID Number and Associated Data)
    By TCooper12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2015, 02:28 PM
  2. Automatically update year interval cycles from year to year
    By trumptight in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2014, 10:38 PM
  3. Keep month and date but change year to current year and reoccur when new year rolls over.
    By cdixon01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  4. How to sum year to date number from different tab
    By Jactey in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-14-2012, 12:38 AM
  5. display number to year, mth and day
    By mrggutz in forum Excel General
    Replies: 7
    Last Post: 03-04-2011, 10:27 AM
  6. Week Number and Year
    By axc0054 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2008, 05:24 PM
  7. [SOLVED] Day number of given date in a year
    By Jeff Gordon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2005, 02:06 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