For example, I have Start Date 29.05.2019, and Finish Date 4.06.2019. I have a formula field which displays 6 days between these 2 dates. But how can I count the number of days from Start Date until the end of the month? I need to get 3 days, including 29.05, 30.05 and 31.05. My reverse formula is here:
Days__c -((TODAY()-DAY(TODAY())+1) - Start_Date__c)
This is for
AND(MONTH(TODAY()) > MONTH(Start_Date__c), MONTH(TODAY()) = MONTH(Finish_Date__c))
How to do the same trick with
AND(MONTH(TODAY()) = MONTH(Start_Date__c), MONTH(TODAY()) < MONTH(Finish_Date__c))
?