replace #Value with 0
Posted on 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()