Closed Thread
Results 1 to 2 of 2

Formula To Add Year and Change Format

  1. 12-16-2019, 10:22 AM #1
    Stenner is offline
    Registered User
    Join Date
    12-09-2014
    Location
    Wales
    MS-Off Ver
    365
    Posts
    85

    Formula To Add Year and Change Format

    Hi,

    In the sample attached I would like to show 11/12/19 02:37 in column A2. I have tried using the formula =date(YEAR(Q2)+19,MONTH(Q2),DAY(Q2)) but it did not work.

    Does anyone have a solution for this?

    Thanks in advance,

    Aarron
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-16-2019, 10:24 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,403

    Re: Formula To Add Year and Change Format

    Administrative Note:

    I have JUST told you not to do this!!!

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread:[ https://www.excelforum.com/excel-for...at-change.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed 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. [SOLVED] Formula To Add Year and Format Change
    By Stenner in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-16-2019, 10:34 AM
  2. [SOLVED] Formula to pick up last change for specific year
    By Keshypops in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2016, 06:04 AM
  3. Help require to change a year format to custom yyyy-yyyy format
    By mso3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-23-2015, 01:04 AM
  4. [SOLVED] want to a formula to change these into month/year format.
    By ljdagr8t in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2014, 10:44 AM
  5. Change text to date format and use if statement to add year.
    By ghstrdr60 in forum Excel General
    Replies: 8
    Last Post: 07-31-2014, 07:53 PM
  6. 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
  7. VBA to convert 1930-1999 year format to year 2000 format
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2011, 04:54 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