CODEWITHSUNDEEP
excelexcel-formulaexcel-2007export-to-excel
Bala S
Bala S

Reputation: 523

How to add month to date in excel

enter image description here

My requirement is I need to add month column into input column. I need output as exactly same date for every input

Upvotes: 1

Views: 143

Answers (2)

Bernard Estephan
Bernard Estephan

Reputation: 56

=EDATE(start date, number of months)

excel

Upvotes: 3

Harun24hr
Harun24hr

Reputation: 36840

Try below Date() formula.

=DATE(YEAR(B2),MONTH(B2)+A2,DAY(B2))

enter image description here

Upvotes: 2

Related Questions