CODEWITHSUNDEEP
excelformula
saw
saw

Reputation: 11

how to show last 12 month date when I enter date/year for excel

i need help with excel,how to show last 12 month date when I enter date/year ,for example if I enter 02 jan 17 then the result will show me 03 feb 16, it show the date for last 12 month.

Upvotes: 0

Views: 60

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34180

=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1)+1)

(does give the right answer even when the current day is the last day of the month)

Upvotes: 1

Related Questions