Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MarioCMarioC 

Formula to push date out 6 months and take into account year carryover

I have a formula that adds 6 months to today's date, but it bombs out when we get to July...  The formula I currently have is- DATE( YEAR(TODAY()) , (MONTH(TODAY()+6)), DAY(TODAY()))

 

How can I get it to increment the year if it is July or after?  I will admit that date formulas seem to be the most confusing things to me. 

 

Thanks in advance.

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

Why not just add 180 days? So your formula is:

 

Date__c + 180
 
Hope that helps,
Sati


All Answers
shillyershillyer
Why not just add 180 days? So your formula is:
 
Date__c + 180
 
Hope that helps,
Sati
This was selected as the best answer
MarioCMarioC
THanks Shilyer.  Sometimes I overcomplicate things...  I was looking for a long formula, when just adding 180days did the job.  Thanks for that.