[#BloggedFormula field to add 1 month exact in close date)


Formula field to add 1 month exact to close date



DATE ( 
YEAR(CloseDate) + FLOOR((MONTH(CloseDate) + 1 - 1)/12), 
CASE(MOD(MONTH(CloseDate) + 1, 12 ), 0, 12, MOD(MONTH(CloseDate)+ 1, 12 )), 
MIN(DAY(CloseDate), 
CASE(MOD(MONTH(CloseDate) + 1,12), 9, 30, 4, 30, 6, 30, 11, 30, 2, 
IF(MOD(YEAR(CloseDate) + FLOOR((MONTH(CloseDate) + 1)/12), 400) = 0 || (MOD(YEAR(CloseDate) + FLOOR((MONTH(CloseDate) + 1)/12), 4) = 0 && MOD(YEAR(CloseDate) + FLOOR((MONTH(CloseDate) + 1)/12), 100) <> 0 
),
29,28),
31)) 
)