Solved

replace #Value with 0

Posted on 2013-10-13
Medium Priority
211 Views
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()

Thanks
0
Question by:Jagwarman
• 2

Author Comment

ID: 39568983
replace #Value with 0 should read

replace #Value with Blank
0

LVL 24

Accepted Solution

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

IF(P2="","",P2-TODAY())

you may find the following more bullet proof:

=IFERROR(IF(P2="","",P2-TODAY()),"")
0

Author Comment

ID: 39568990
Thanks The_Barman exactly what I need.
0

Featured Post

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.