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

 

[Get_Involved]

		Date & Time of Discount	Date Before Next Lower Discount Drop	30-Apr-20
	31-Jan-20
Item Number	Days Left to Make a Discount	Sold	Date Sold	Brand Name	New or Used	Description	Size
0	43861	Discount	12/19/2019	Wrangler	Used	Ladies Western Shirt	Large

Everything in this jpg is in the same spot as the formula, I did move the Start Date to F2, & the end date to I2 so you can see it
Hope this works for you

 

[Fluff]

That looks suspiciously as though the cell where 30-Apr-20 is located is a merged cell.
Is that the case?

 

[Get_Involved]

It is

 

[Fluff]

In that case that's your problem, if P1:P2 is a merged cell P2 is blank.
Change your formula to look at P1

 

[Get_Involved]

I got it, I unmerged the cells and widened P2 this is the formula I made to get it to work

=IF(AND(D31="Discount",$F$2>=0),-(NOW()-$I$2),"")

Thank you, I have been working on that for over a week, merged cell was the main problem
Thank You

 

[Fluff]

Glad it's working & thanks for the feedback.
It's best to avoid merged cells as they can cause all sorts of problems, as you've discovered.