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]

I have a formula that makes the date 90 days later, all static
=J2 + 90
I type in the date in J2, P2 has this formula=J2 + 90

 

[Fluff]

In that case can you use the XL2BB add-in to post a sample of your data your the problem?

 

[Get_Involved]

Publish your Excel sheets as interactive web pages

Convert spreadsheets to web pages with formula support, right from within Excel. No coding required.

www.publisheet.com

 

[Fluff]

I get an error "This web page is currently unavailable. " with that link.

 

[Get_Involved]

Hope this one works says successful

Publish your Excel sheets as interactive web pages

Convert spreadsheets to web pages with formula support, right from within Excel. No coding required.

www.publisheet.com

 

[Fluff]

That's better but I'm now being asked for a password.
Can you just use the XL2BB add-in?

 

[Get_Involved]

I downloaded it again when I sent the second and it opens as publisher.
I downloaded it the third, and it does the same.
I don't know what to do now.
Thanks I won't bother you anymore, Thanks

 

[Fluff]

Are you referring to the XL2BB add-in?

 

[Get_Involved]

Yes Sir I am

 

[Fluff]

It should download as a Zip file & inside that there should be the xl2bb.xlam file.
If you try & open the xl2bb.xlam file & it's opening in publisher then at some point your system has been changed as the default for xlam files is Excel.
Did you follow the instructions here on how to install it?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com