[#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)) 
)