Dates Difference with condition

[smartkrawler]

Hi, I am stuck on a small problem. I need to calculate the difference between two dates in two different columns in "days". It needs an example to understand, as given below:

31-01-2018 - 17-03-2018 = 45 Days
31-01-2018 - 06-05-2018 = 95 Days

If the difference between the dates is more than 1 month, I need only "days" calculated from 2nd date only, i.e. "17 Days" in this case.

Can anybody help me, please? Thanks

[Sam Capricci]

this might work, but this assumes a lot.
=IF(DATEDIF(A2,B2,"d")<31,DATEDIF(A2,B2,"d"),B2-DATEVALUE(MONTH(B2)&"/1/"&YEAR(B2)))

first, it assumes that these 31-01-2018 - 17-03-2018 are in their own cells, for example A2 and B2 respectively
second, it assumes that "the dates is more than 1 month" is a 30 day month.
third, it assumes the way I wrote it will work for you because my system uses mm/dd/yyyy while your dates showed as dd/mm/yyyy.
fourth, it assumes that when you say "17 days" if greater than 1 month you are meaning that you want the first of the month to be subtracted from the 17th of the month.
lastly mine returns 16 rather than 17 but that can be adjusted with this change...
=IF(DATEDIF(A2,B2,"d")<31,DATEDIF(A2,B2,"d"),B2-DATEVALUE(MONTH(B2)&"/1/"&YEAR(B2))+1)

[Root_]

Is this what you need?

=IF(A2>=EDATE(B2,-1),B2-A2,DAY(B2))