+ Reply to Thread
Results 1 to 3 of 3

Formula for today remark

  1. 01-07-2014, 09:48 AM #1
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Formula for today remark

    Hello friends,
    I have dates in column A a6:a5000. I need a formula to add a remark "Today" in column B for the current date. In short the remark in column B should display the remark "Today" for the current date daily. The dates in column A are in 'DD MM YYYY'.
    Thanking you in anticipation.

    Sincerely,
    Mukesh
    Last edited by mukeshbaviskar; 01-07-2014 at 09:55 AM.
    Reply With QuoteRegister To Reply
  2. 01-07-2014, 09:53 AM #2
    ragulduy
    ragulduy is offline
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Formula for today remark

    put in B6:
    =if(A6=TODAY(),"Today","")
    and copy down
    Reply With QuoteRegister To Reply
  3. 01-07-2014, 11:31 AM #3
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Formula for today remark

    Hi yudlugar,
    Thank you for formula. It's working fine.

    Thank you.

    Mukesh
    Reply With QuoteRegister To Reply
+ Reply to 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] Conditional Remark
    By santosh226001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 07:09 AM
  2. Remark update in another sheet
    By dingdang in forum Excel General
    Replies: 0
    Last Post: 12-01-2013, 09:45 AM
  3. [SOLVED] Conditional remark based on if function
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2013, 07:19 AM
  4. Remark several line in the code
    By michael1963 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2009, 02:46 AM
  5. [SOLVED] Excel makes it possible:celverwijzing to a remark on another page
    By Jos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2005, 06:30 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