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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks