Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

tricky if formula

Hi experts excel 2007

Need a if formula to do the following..

If a2 has the txt complete then b2 equals todsys date format 01/02/2014 if a2 does not have the txt complete then d2.
0
route217
Asked:
route217
1 Solution
 
Naresh PatelTraderCommented:
txt complete

what do u mean by this?
0
 
route217Author Commented:
The word complete. .in cell
0
 
Santosh GuptaCommented:
try

=IF(A2="Complete",TEXT(TODAY(),"dd/mm/yyyy"),D2)
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
route217Author Commented:
Hi gupta

Thanks for the formula but I am getting date as 00/01/1900. .
0
 
Naresh PatelTraderCommented:
I guess I am late in reply... :)  enjoy
0
 
route217Author Commented:
My fault. .fixed
0
 
clarkscottCommented:
format column B as date  (mm/dd/yyyy)

In column B:

=if(A2 = "COMPLETE", Now(), D2)

??

Scott C
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now