amend if formula to remove 00/01/1900

Hi Expert's Excel 2007

I need to amend the following formula

so if d2 is blank the return blank and not 00/01/1900 as date field where every I insert this formula.
Who is Participating?
Naresh PatelConnect With a Mentor TraderCommented:
Try this

Open in new window

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