How to display current month and previous month in same sheet

[Naagi]

hi,


I have created a drop down list which contains months.
i have two boxes one displays current month and orther displays prev month
if i select a month from drop down list current month displays and previous month should display automatically

for current month i have used formula: concatenate("current month"(",e2,"-15)")=current month mar-15
for previous month i need to display automatically based on current month.

Please help me out

 

[Hui]

Naagi

Firstly, Welcome to the Chandoo.org Forums

Try:
="Previous month ("&TEXT(EOMONTH(1&E2,-1),"mmm-yy)")

 

[Naagi]

Naagi

Firstly, Welcome to the Chandoo.org Forums

Try:
="Previous month ("&TEXT(EOMONTH(1&E2,-1),"mmm-yy)")

Thanks a lot.

 

[Naagi]

And that month value should be displayed in below box of the month what we are getting

 

[Naagi]

As if we select mar then for curr box we need to get curr month name and that month value should display and for prev month it should display prev month name and vallue of that month in the box

 

[Hui]

That formula will need to be in a cell
Then link a text box to the cell
Select the text box
In the formula bar type: =$A$1
change to the address where the formula is

If that doesn't make sense please post the file