Need help wit this formula

[Get_Involved]

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

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

 

[Michael M]

What is in P2 currently
Try
=IF(AND(D31="Discount",$J$2>=0),TODAY()-$P$2,"")

 

[Get_Involved]

Thank you Michael M

30-Apr-20​

 

[Get_Involved]

Michael M:
It is still returning the month formatted as 1/20/2020

 

[Get_Involved]

IF(AND(D31="Discount",$J$2>=0),(NOW()-$P$2),"")

It is returning the number (43850.07) which is 1/20/20

The answer is supposed to be 90 days

 

[Fluff]

What is in P2?

 

[Get_Involved]

Fluff
P2 has a date of 4/20/20

 

[Fluff]

In that case with the formula @Michael M suggested in post#2 I get -91
The only way I can get the result to are reporting is if P2 is blank.

 

[Get_Involved]

Fluff
yea it will negative
I have a start date in J2, end date 90 days later in P2
I can't change my Text "discount" in D31 for 90 days
My original formula is giving the correct number (43850.07) i just need it to read the number days left to get to P2
I have tried dividing by 365, it still gives me (4385.07),
P2 has a date of 4/30/20
C31 Needs to read days left, (note this number changes as today get closer to P2)
I hope I explained it clear enough

Sorry

 

[Fluff]

Is P2 just the date or is it a formula?
As I said I get only get your result if P2 is empty.