+ Reply to Thread
Results 1 to 2 of 2

Returning the date based on conditions

  1. #1
    Registered User
    Join Date
    10-02-2003
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    46

    Returning the date based on conditions

    Is it possible to return the date based on conditions. Ie., the date on which the conditions satisfied.
    I have formula on A2 =and(a1=b1,C1=D1). Can excel return the date of which this formula returns true.
    Thanks,
    Itty

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    You mean something like, A2: =IF(AND(A1=B1,C1=D1),SaveTODAY(),"") ?
    Excel can normaly* not "Save" a TODAY() value. It has to be hard coded e.g. "2005-12-31".

    *But some VBA code can solve your problem. Try post a question in the Programming forum.

    Ola Sandström
    Last edited by olasa; 03-06-2005 at 07:25 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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