Add X number of months to a date in Excel
=MIN(DATE(YEAR(A2);MONTH(A2)+B2+{0;1};DAY(A2)*{1;0}))
Add X months to date (example)
1 file(s) 10.73 KB
Add X number of months to a date in Excel
=MIN(DATE(YEAR(A2);MONTH(A2)+B2+{0;1};DAY(A2)*{1;0}))