You need to sign in to do that
Don't have an account?
Leslie Collins 5
Calculating number of days in a period, not looking at years
I have a list of contracts with start dates and end dates, most of them within multiple year periods (start date: 5/8/2013 end date: 5/9/2020). I need a formula to tell me how many days are left the current 12 month period (5/8/2017 - TODAY) because they have committed to purchasing a product every 12 months within their contract timeframe. I need the formula to not look at the years, just the month/day. Ideas? I can get it to work in Excel, not in SF. Thanks.
Do you need to find the days between End Date and Start Date?
If yes, then you can create formula number field ans use like End_Date-Start_Date.
Thanks,
Saravana
No, I need to find the number of days between two dates but not taking into consideration the year.
Sorry for the late response.
Please use the below formula.
TEXT(Month( End_Date__c )-Month( Start_Date__c )) &" "&"months"&" "&
TEXT(Day( End_Date__c )-Day( Start_Date__c ))&" "&"days"
Let me know if it works.
Thanks,
Saravana
With a contract with a start date of 11/1/15 and an end date of 10/31/2020 the result of the formula you provided was: -1 months 30 days
Using this example, what I need is the number of days between 11/1 and 10/31 (the answer would be 365)
Ultimately what I need is the number of days between the start date (11/1) and TODAY but if I can get the above working I can probably figure this one out.
Please use the below formula.
DATE(Year(Start_Date__c)+1,month(Start_Date__c),day(Start_Date__c) )
-
DATE(Year(Start_Date__c),month(End_Date__c),day(End_Date__c) )
Please let me know if it works..
Thanks,
Saravana