amend if formula to remove 00/01/1900

Hi Expert's Excel 2007

I need to amend the following formula

=IF(A2="Complete",TEXT(TODAY(),"dd/mm/yyyy"),D2)
so if d2 is blank the return blank and not 00/01/1900 as date field where every I insert this formula.
route217Asked:
Who is Participating?
 
Naresh PatelConnect With a Mentor TraderCommented:
Try this
=IF(A2="Complete",TEXT(TODAY(),"dd/mm/yyyy"),IF(D2="","",D2))

Open in new window

0
 
route217Author Commented:
Thanks for the feedback itjockey. ..
0
 
Naresh PatelTraderCommented:
You Are So Fast In Asking & Accepting !!! :)
0
 
route217Author Commented:
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.

All Courses

From novice to tech pro — start learning today.