+ Reply to Thread
Results 1 to 10 of 10

Getting Today's Year to Update a Date in a Cell

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    94

    Question Getting Today's Year to Update a Date in a Cell

    Hi I have a form with some date fields. Some of the date fields need to change depending on the current year. For example:

    Cells
    A1
    B1
    C1

    Have 12/31/2013 (December 31 2013, US style), but I want it to automatically change to 12/31/2014 when it becomes 2014,15,16 and so on.

    Thank you
    Last edited by karimel_romeo; 10-07-2013 at 03:31 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Getting Today's Year to Update a Date in a Cell

    You get better help on your question if you follow the advice in the link below.

    http://www.excelforum.com/the-water-...-question.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Getting Today's Year to Update a Date in a Cell

    The attached doc may be of some help in understanding the requirement
    Attached Files Attached Files

  4. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Getting Today's Year to Update a Date in a Cell

    Use

    =DATE(YEAR(TODAY()),12,31)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Getting Today's Year to Update a Date in a Cell

    d6="31-12-"&year(D5)

    See the attached file.
    Attached Files Attached Files

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,574

    Re: Getting Today's Year to Update a Date in a Cell

    Yes I agree. Posting a question without uploading a workbook takes more time for members to understand the exact requirement. It certainly help us to know the exact issue well.
    Please upload a sample workbook.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Getting Today's Year to Update a Date in a Cell

    Here's another one...

    =--("12/31/"&YEAR(NOW()))

    Format as Date
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  8. #8
    Registered User
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Getting Today's Year to Update a Date in a Cell

    Thank you all, and thanks for advice for future posts. SOLVED!!

  9. #9
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,574

    Re: Getting Today's Year to Update a Date in a Cell

    Quote Originally Posted by karimel_romeo View Post
    The attached doc may be of some help in understanding the requirement
    Please see the attachment and confirm if you want it to work like this.
    Attached Files Attached Files

  10. #10
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Getting Today's Year to Update a Date in a Cell

    You're welcome. Thanks for the feedback!

+ 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. [SOLVED] Compare with Date TODAY function, and have resulted in year to DateDiff Via VBA
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2012, 01:18 PM
  2. [SOLVED] Excel 2007 : Convert Today's Date To The Previous Month & Year
    By The_Snook in forum Excel General
    Replies: 8
    Last Post: 04-26-2012, 06:37 AM
  3. Replies: 1
    Last Post: 06-09-2010, 01:05 PM
  4. Display today date as quorters of the year macro
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2008, 08:36 AM
  5. [SOLVED] get date with now() today() but dont update with recalc
    By robert w in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2006, 08:40 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