Help with Days360 Formula

[heybakes]

Hello Everyone,

First post here and I could use some help. Days360(7/1/2017,6/30/2018) gives me 359 days when Days360(1/1/2017,12/31/2017) gives me 360. How do I get the former to give me 360 or is there something inherently true with the former formula that will always give me 359? I have also found that I get 359 when I use True or False.

Can anyone help me out? Thank you!
heytbakes

 

[footoo]

Days360(1/1/2017,12/31/2017) gives me 360

Are you sure? It should return 359.

If you want the number of days inclusive if the start and end dates (as opposed to the difference in the dates) you need to add 1 to your formula :
=Days360(7/1/2017,6/30/2018)+1