+ Reply to Thread
Results 1 to 4 of 4

"Semi-dynamically" displaying system date, year-by-year

  1. #1
    Registered User
    Join Date
    02-26-2015
    Location
    Central Maryland
    MS-Off Ver
    2010
    Posts
    8

    "Semi-dynamically" displaying system date, year-by-year

    Hi there: How do I get a cell to display either the first day of the current year or the last day of the current year? Meaning that let'say A2 would show 1/1/2016 all the way until New Year's Day, then switch automatically to 1/1/2017. Same idea for the other end: B2 would always show 12/31/2016 all the way until New Year's Day, then switch automatically to 12/31/2017.

    Thanks in advance! Bill

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: "Semi-dynamically" displaying system date, year-by-year

    Maybe this?
    1st oif the year
    =date(year(today(),1,1)
    last of the year
    =date(year(today(),12,31)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-26-2015
    Location
    Central Maryland
    MS-Off Ver
    2010
    Posts
    8

    Re: "Semi-dynamically" displaying system date, year-by-year

    Other than a missing ")" this is perfect. Many thanks!

    =date(year(today()),1,1)
    =date(year(today()),12,31)

    Bill

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: "Semi-dynamically" displaying system date, year-by-year

    oops yup, missed that when I typed it in here lol, sorry

    Happy to help, 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] Comparing the number "2015" to the year value of a date
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2015, 01:22 AM
  2. Replies: 1
    Last Post: 06-05-2014, 09:48 AM
  3. Date/Month/Year formatting for column "c" not working for me...
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-02-2013, 10:37 PM
  4. [SOLVED] making a "if" function that uses only the month/year values from a date
    By ATraveller in forum Excel General
    Replies: 6
    Last Post: 10-02-2012, 03:43 AM
  5. [SOLVED] Update from "August" workbook to "year to Date"-workbook
    By esbenhaugaard in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 08-20-2012, 03:30 PM
  6. Replies: 2
    Last Post: 06-11-2012, 06:08 PM
  7. [SOLVED] Setting up "Year to Date" Calculations in a Pivot Table
    By Project64 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2005, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1