+ Reply to Thread
Results 1 to 8 of 8

How to fix today formula

  1. #1
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Unhappy How to fix today formula

    Dear all,

    how to let the date in column B conserve its value from yesterday unchanged in the following day??

    when using "Today" function all dates in column B are changed and take the value of today!
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: How to fix today formula

    I think you need vba micro. Try with below., but i am not sure / tested.
    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range
    If 
    Not Application.Intersect(Target, [B2]) Is Nothing Then 
    [A2] = Date 
    End 
    If 
    End Sub 


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    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,917

    Re: How to fix today formula

    Or, enter the date manually. =TODAY will always update from 1 day to the next...no way around that, it is doing what it is supposed to do

    A shortcut to enter todays date Ctrl+semi-colon (
    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

  4. #4
    Forum Contributor
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    122

    Re: How to fix today formula

    Hi,

    Try this, its will not change date for next day.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: How to fix today formula

    useful for today' date

  6. #6
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: How to fix today formula

    Quote Originally Posted by avk View Post
    I think you need vba micro. Try with below., but i am not sure / tested.
    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range
    If 
    Not Application.Intersect(Target, [B2]) Is Nothing Then 
    [A2] = Date 
    End 
    If 
    End Sub 
    Dear AVk,
    I've tried it, didn't work
    Have any idea to solve this????

    Regards

  7. #7
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: How to fix today formula

    Quote Originally Posted by avk View Post
    I think you need vba micro. Try with below., but i am not sure / tested.
    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range
    If 
    Not Application.Intersect(Target, [B2]) Is Nothing Then 
    [A2] = Date 
    End 
    If 
    End Sub 
    Dear AVk,
    I've tried it, didn't work
    Have any idea to solve this????

    Regards

  8. #8
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: How to fix today formula

    Quote Originally Posted by ExcelUser2707 View Post
    Hi,

    Try this, its will not change date for next day.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I am sorry,
    but it didn't work
    date is updated next day!

    how fix this?

+ 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. Replies: 10
    Last Post: 09-06-2023, 08:19 PM
  2. [SOLVED] Formula With TODAY ()
    By PaddyP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2016, 05:13 PM
  3. Need help with a if(and formula with today() please!
    By seannormand in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 09:50 AM
  4. [SOLVED] Counting Tasks With Due Dates between TODAY and TODAY+7
    By Erik_with_a_K in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-29-2013, 09:00 AM
  5. Replace today() with a hardcoded value representing today in all tabs
    By Romanian37 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2013, 07:03 AM
  6. Excel 2007 : Today() Formula
    By Ozzie1121 in forum Excel General
    Replies: 18
    Last Post: 02-14-2012, 07:06 AM
  7. Replies: 3
    Last Post: 12-11-2007, 01:36 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