Get_Involved
Active Member
- Joined
- Jan 26, 2007
- Messages
- 383
I have searched,and restructured the formula all this and can't get to retu
I have this formula that is supposed to give the number of days from Cell “P2”
It is returning the number (43850.07) which is 1/20/20
The answer is supposed to be 90 days
These cell numbers are the cell numbers I am using, also I have even tried to reformat the cells each way possible
I have this formula that is supposed to give the number of days from Cell “P2”
It is returning the number (43850.07) which is 1/20/20
The answer is supposed to be 90 days
Code:
IF(AND(D31="Discount",$J$2>=0),(NOW()-$P$2),"")
These cell numbers are the cell numbers I am using, also I have even tried to reformat the cells each way possible