replace #Value with 0

Posted on 2013-10-13
Medium Priority
Last Modified: 2013-10-13
I am struggling with a formula and would appreciate some help.

P2 contains a date. I need to find how many days between today and the date in P2

So if P2 is 15/11/13 and today is 13/10/13 return 33 but if P2 is Blank, return Blank.

I need to say :

If P2 is Blank return blank but if P2 is not blank return P2- Today()

Question by:Jagwarman
  • 2

Author Comment

ID: 39568983
replace #Value with 0 should read

replace #Value with Blank
LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 39568985
This should do it:


you may find the following more bullet proof:


Author Comment

ID: 39568990
Thanks The_Barman exactly what I need.

Featured Post

Upgrade your Question Security!

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

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question