Results 1 to 4 of 4

Thread: Date Formula

  1. #1

    Question Date Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am having trouble with a formula in excel 2007. If I have a cell say A1 = 9/17/11 and I want to populate C1 automatically with the same month and day but want the year to be the current year how do I do that. I have tried everything I can think of. Can someone please help.

  2. #2
    Use this formula:
    =VALUE(MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)+1)
    and format the result as a date.

  3. #3
    Try

    =DATE(YEAR(TODAY),MONTH(A1),DAY(A1))

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Bob, shouldn't it be today() instead of today ( without brackets) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •